Instruction for Question 2

Question 2 is to transform the ERD for car dealership (below) into 3NF relations using MySQL.

The deliverable for Question 2 would be a MySQL Workbench Model (.mwb). You can save your model in the following way.

Tools Scripting Help MySQL Model X EER Diagram X File Edit View Arrange Model Database New Model Cile Open Model Corleo Include Model. Open Recent Close Tab Chow Save Model Cales Save Model As Cole Shites Import Export Page Setup. Print Preview Print Print to File Document Properties Exit Routine Groups KTOB table2 CleP Pdtable2 INT table? Alt-F4 @ idtable INT table2_dtable2 INT . F File name: Save as type: MySQL Workbench Models (*.mwb) = F lide Folders Save Cancel Convert the ERD into a relational model so that all tables are in 3NF using MySQL. - You need to define PK and FK, as well as data type for each attribute. If any, please state clearly your assumptions. Car PK Salesperson Salesperson ID Last Name First Name 0 PK Sales Invoice Invoice ID HOTH PK Invoice Number Date Car ID Serial Number Model Manufacturer Color Year Used Car Y/N PK Customer Customer ID Last Name First Name Address (City, State, Country Postal Code) Mechanic Service Mechanic Part PK Service Mechanic PK Mechanic ID Last Name First Name 04 > Service Ticket PK Ticket ID Ticket Number Date Received Date Returned to Customer PK Service-Part Service Part IDO Number Used Hours Rate Part ID Part Number Price (Subparts) The cardinalities could be different depending on the assumptions. * Note that Subparts (multivalued attribute) is not included in the requirements of Assignment 1 Tools Scripting Help MySQL Model X EER Diagram X File Edit View Arrange Model Database New Model Cile Open Model Corleo Include Model. Open Recent Close Tab Chow Save Model Cales Save Model As Cole Shites Import Export Page Setup. Print Preview Print Print to File Document Properties Exit Routine Groups KTOB table2 CleP Pdtable2 INT table? Alt-F4 @ idtable INT table2_dtable2 INT . F File name: Save as type: MySQL Workbench Models (*.mwb) = F lide Folders Save Cancel Convert the ERD into a relational model so that all tables are in 3NF using MySQL. - You need to define PK and FK, as well as data type for each attribute. If any, please state clearly your assumptions. Car PK Salesperson Salesperson ID Last Name First Name 0 PK Sales Invoice Invoice ID HOTH PK Invoice Number Date Car ID Serial Number Model Manufacturer Color Year Used Car Y/N PK Customer Customer ID Last Name First Name Address (City, State, Country Postal Code) Mechanic Service Mechanic Part PK Service Mechanic PK Mechanic ID Last Name First Name 04 > Service Ticket PK Ticket ID Ticket Number Date Received Date Returned to Customer PK Service-Part Service Part IDO Number Used Hours Rate Part ID Part Number Price (Subparts) The cardinalities could be different depending on the assumptions. * Note that Subparts (multivalued attribute) is not included in the requirements of Assignment 1