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.
1 answer:
You might be interested in