ABC company is a car dealership that operates a service facility. A salesperson may sell many cars, but each car is sold by only one salesperson.o A salesperson has a unique id$,$ a first name, and a last name.o Each car has its unique VIN number, make, model, color, and year. A customer may buy many cars, but each car is bought by only one customer. Each invoice has its invoice number, date of transaction.o A salesperson writes a single invoice for each car he or she sells.o 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.o A service ticket has its unique number, date received and date returned.o The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the cars VIN number. Each service ticket may include many different services and the same service $($i$.$e$.,$ oil change$)$ can be done for many different service tickets. o A service has its ID$,$ name, and hourly rate.o For a given service ticket and a specific service, only one mechanic is assigned. But the same mechanic can work for other services $($in different service tickets$).$o Each mechanic has his$/$her ID$,$ first name, and last name.