composition .The symphony orchestra wishes to record the date when a soloist last performed a given composition (Date Last Performed ). a. Draw an ER Diagram to represent what you have discovered b. Create a relational model based on the ER diagram 2} Car Dealership Create an ER diagram and relational model for a car dealership .Ihe 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 custom er need not buy a car to be classied 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. ' A car brought in for service can be worked on by many mechanics, and each mechanic may work on many cars. ' 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 ). a. Draw the ER diagram b. Create a relational model based on the ER Diagram