3. A piano manufacturer wants to keep track of all the pianos it makes individua

Question

3. A piano manufacturer wants to keep track of all the pianos it makes individually. Each pi identifying serial number and a manufacturing completion date. The piano manufacturer piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least one technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade. The following is the entity-relationship diagram for the piano inspection. Your task is to transform this ER diagram to a relational data model. ano has an employs PIANO TECHNICIAN SerialNumber ManufacturingCompletion Date EmploveeNumber InspectionDate QualityGrade

Explanation / Answer

Relational Tables

PIANO(SerialNumber,ManufacturingCompletionDate)

TECHNICIAN(EmployeeNumber)

INSPECTION(EmployeeNumber,SerialNumber,InspectionDate,QualityGrade)

underlined attributes are primary keys and italicised attributes are foreign keys. Some attributes are both.

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.