Question

Problem 1 (10%): You are asked to design a database for an auto-shop that satisfies the following requirements: a. Each customer has a unique customer identification number, a name, address, day time telephone number, evening telephone number. The customer name includes first name, middle initial and last name. The address includes street address, city, state, and zip code. The telephone numbers include area code and the number. b. Each car type has a unique type name, the make, model, and year of make. c. The car has a unique license number, a car type, color, type of transmission, and the customer who brings the car to the auto-shop. d. The database keeps records of repairs. The repair record includes the date of the repair, the car that the repair was done, the name of the engineer who did the repair, and the cost of the repair.

Answer 1

see explaination

Step-by-step explanation:

I am considering some relationship for this ER Diagram as follows :

(i) One Car can have only one type.

(ii) One Car needs more than one repairings.

(iii) A customer can have more than one car and a car must belong to only one customer.