Finalizing our model for the Piano Manufacturers database (Problem 7 in our Exercise Sheet):

As we present our proposal to the board of "Ebony and Ivory, we are informed that there are additional considerations needed for the database. Specifically, we learn that:

The Piano technicians (see (problem 6) above) have a hierarchy of reporting relationships: some of them have supervisory responsibilities in addition to their inspection role and have multiple other technicians report to them. The supervisors themselves report to the chief technician of the company.

Please answer the following questions in order to add the final touches to the database model:

Q8. What entities and attributes do each business rule (sentence) suggest we should include in the model?

Rule 1:

Rule 2:

Q9. What relationships can you identify in the statements above?

A.:

Q10. Please draw a model of the needed database including the inferences made above (entities, attributes, and relationships).

Q11. Take the models built for the last three problems (the models made for Ebony & Ivory) and combine them so that we can present the full database model to the Board of the company. Please add your full model below: