Use scenario to construct an Entity -Relationship Diagram for each question

• Clearly show identifier attribute(s) and all other attributes of all the entities in the ERD.

• If a scenario doesnt specify an identifier, make one for each entity.

• Clearly indicate the cardinality mappings.

• Please write down any assumptions you make.

• You can Hand write or type or draw the answer

• Scenario

• A piano manufacturer wants to keep track of all the pianos it makes. Each piano has an identifying serial number and a manufacturing completion date. Each piano belongs to exactly one piano model. A model number identifies each model and the company also stores a name of each model. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists.

0. A piano manufacturer employs piano technicians who are responsible for inspecting the pianos before they are shipped to the customers. Each piano is inspected by at least one technician (identified by their employee number). Technicians are expected to inspect multiple pianos simultaneously. For each separate inspection, the company needs to record its date and a quality grade.