1.Draw a full ER diagram for the following requirements: The car dealership database stores details considering the following requirements: 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. The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the cars serial number. A car that is serviced may or may not need parts (e.g., adjusting a carburetor or cleaning a fuel injector nozzle does not require providing new parts). Add your own 3-4 meaningful attributes based on common sense

2. Write the database schema of the ER diagram in 1. You must make your design in 3NF and describe how your design is in 3NF.

3. Write SQL codes to implement the database schema in 2.