Ebony and Ivory (see (problem 5) above) employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least two technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.

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

Rule 1:

Rule 2:

Rule 3:

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

A.:

Q6. Are there any characteristics/properties of the relationship that we should consider and model? If so, which are they?

A.:

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