Question

Create a simple ERD for a car dealership. Convert the diagram to a PDF file. The dealership sells both new and used cars, and it operates a service facility. Base your design on the followirg business

asked Mar 17, 2021 31.6k views

Create a simple ERD for a car dealership. Convert the diagram to a PDF file. The dealership sells both new and used cars, and it operates a service facility. Base your design on the followirg business rules: A salesperson may sell many cars, but each car is sold by only Acustomer may buy many cars, but each car is bought by only A salesperson writes a single invoice for each car he or she sells A customer gets an invoice for each car he or she buys. Acustomer may come in just to have his or her car serviced; that is, a customer need not buy a car to one salesperson one customer. be classified as a customer. When a customer takes one or more cars in for repair or service, one service ticket is written for each . car. The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the car's serial number. Acar brought in for service can be worked on by many mechanics, and each mechanic may work on many cars. Acar that is serviced may or may not need parts