Question: composition .The symphony orchestra wishes to record the date when a soloist last performed a given composition (Date Last Performed ). a. Draw an ER

composition .The symphony orchestra wishes to
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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!