Question: Create the initial ER diagram for a car dealership. The dealership sells both new and used cars, and it operates a service facility. Base your
- Create the initial ER diagram for a car dealership. The dealership sells both new and used cars, and it operates a service facility. Base your design on the following business rules:
- A salesperson can sell many cars, but each car is sold by only one salesperson.
- A customer can buy many cars, but each car is sold to only one customer.
- A salesperson writes a single invoice for each car sold.
- A customer gets an invoice for each car(s) he buys.
- A customer might come in only to have a car serviced; that is, one need not buy a car to be classified as a customer.
- When a customer takes in one or more cars for repair or service, one service ticket is written for each car.
- The car dealership maintains a service history for each car serviced. The service records are referenced by the cars serial number.
- A car brought in for service can be worked on by many mechanics, and each mechanic can work on many cars.
- A car that is serviced may or may not need parts. (For example, parts are not necessary to adjust a carburetor or to clean a fuel injector nozzle.)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
