Use Scenario Construct Entity Relationship Diagram Question Clearly Show Identifier Attrib Q43876532
Use scenario to construct an Entity -Relationship Diagram foreach question
-
Clearly show identifier attribute(s) and all other attributes ofall the entities in the ERD.
-
If a scenario doesn’t specify an identifier, make one for eachentity.
-
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 itmakes. Each piano has an identifying serial number and amanufacturing completion date. Each piano belongs to exactly onepiano model. A model number identifies each model and the companyalso stores a name of each model. Over time, the company oftenmanufactures thousands of pianos of a certain model, and the modeldesign is specified before any single piano exists.
-
A piano manufacturer employs piano technicians who areresponsible for inspecting the pianos before they are shipped tothe customers. Each piano is inspected by at least one technician(identified by their employee number). Technicians are expected toinspect multiple pianos simultaneously. For each separateinspection, the company needs to record its date and a qualitygrade.
Expert Answer
Answer to Use scenario to construct an Entity -Relationship Diagram for each question Clearly show identifier attribute(s) and all…
OR