Read the case study and find the entities and attribute and make ERD Diagram? Car Dealership Create an ERD for a car dealership. The dealership sells both new and used cars, and it operates a service...

 Read the case study and find the entities and attribute and make ERD Diagram?

Car Dealership

Create an ERD 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 may sell many cars, but each car is sold by only one salesperson.


• A customer may buy many cars, but each car is bought by only one customer.


• 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.


• A customer may come in just to have his or her car serviced; that is, a customer need not buy a car to 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.