Car Car Dealership PK Car_ID Serial Number Make Model (0,1) (1,1) Colour Sales Invoice Year Car for Sale Y/N Salesperson PK Invoice_ID Customer PK Salesperson_ID (1,") (1,1) Invoice Number (1,1) PK...

Please help with the database system question down below: Illustrate a instance of sales invoice and sales person subsequently determine degree, cardinality, candidate key(s), and alternate key(s) for each instanceCar<br>Car Dealership<br>PK Car_ID<br>Serial Number<br>Make<br>Model<br>(0,1)<br>(1,1)<br>Colour<br>Sales Invoice<br>Year<br>Car for Sale Y/N<br>Salesperson<br>PK Invoice_ID<br>Customer<br>PK Salesperson_ID<br>(1,

Extracted text: Car Car Dealership PK Car_ID Serial Number Make Model (0,1) (1,1) Colour Sales Invoice Year Car for Sale Y/N Salesperson PK Invoice_ID Customer PK Salesperson_ID (1,") (1,1) Invoice Number (1,1) PK Customer_ID Date FK1 Car ID (Foreign) FK2 Customer ID (Foreign) FK3 Salesperson ID (Foreign) (0,") Last Name First Name (1,1) Last Name First Name Phone Number (0,") Address (1,1) City State/Province Country Postal Code Service Ticket (0,*) PK Service_Ticket_ID Mechanic Service Ticket Number (1,1) FK1 Car ID (Foreign) FK2 Customer ID (Foreign) Date Received PK Mechanic_ID Last Name First Name Comments Service (1,1) Date Returned to Customer PK Service_ID (1,1) (1,") Service Name (0,") (1,1) Service Mechanic Hourly Rate PK ServiceMechanic_ID (1,) FK2 Service Ticket ID (Foreign) FK3 Service ID (Foreign) FK1 Mechanic ID (Foreign) (0,") Parts Used Parts PK Parts_Used_ID (1,") (1,1) PK Parts_ID Hours Comment FK1 Part ID (Foreign) FK2 Service Ticket ID (Foreign) Number Used Part Number Description Purchase Price Rate Price Retail Price

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here