An E/R diagram for your proposed database. Underline key attributes for entity s

Question

An E/R diagram for your proposed database. Underline key attributes for entity sets, specify relationships and their multiplicities.   (10 pts)

If its possible create a new ER diagram or edit this one. Thank you a lot.

Social Security_Number Employment ID First Name Last Name Phone Number Address ISA Hire_Date Auto Salesman Auto Mechanic Support staff Name Product ID Purchase Buying a Vehicle Selling a Vehicle Order ID Product ID Name Date Order Name Vehicle Parts Product ID Date Order ID Repairs On Transmission Vehicle Milleage ration Number of seats Manufacturer License Insurance_number Insurance Fuel type requiremen Number of previous owners Email _address VIN Number Auto Slot Number of doors Vehicle Model Customer ID Status Number ot wheels Social Address Sales Purchase Pri creately First Name Last Name Online Dizgramming

Explanation / Answer

Key Attributes For Attributes :

(i) For Employment : Social_Security_Number

(ii) Support Staff : Staff_ID

(iii) Administrator : Unique_ID

(iv) Auto Salesman : Salesman_ID

(v) Vehicle Parts : Product_ID

(vi) Vehicle : VIN_Number , License_Plate_Number , Registration_Number

(vii) Customer : Social_Security_Number

Relationships :

(i) 1 Customer can buy N vehicle from a auto salesman , Similarly N Customers can buy M vehicles from auto salesman. So , 1:N---N:M multiplicity between Customer and Auto Salesman.

(ii) 1 Employment can have only 1 support staff. So , 1:1 multiplicity between Employment and Support Staff.

(iii) 1 Employment can have only 1 Administration. So , 1:1 multiplicity between Employment and Administration.

(iv) 1 Administration can buy N vehicle Parts , Similarly N Administration can buy M vehicle parts. So , 1:N---N:M multiplicity between Administration and Vehicle Parts.

(v) 1 Auto Salesman manages 1 Employment. So 1:1 multiplicity between Auto Salesman and Employment.

(vi) 1 Auto Salesman can purchase N Vehicles. So , 1:N multiplicity between Auto Salesman and Vehicle.

(vii) 1 Vehicle needs N Vehicle Parts for repairing. So , 1:N multiplicity between Vehicle and Vehicle Parts.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.