Write the entities , attributes and relationship in this text .Make sure select the correct types of attributes, assign an identifier, and describe

the minimum maximum cardinality constraints as well.

A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a

manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and a

name. In addition, the company wants to maintain information about the designer of the model. An employed designer may not have

designed any models yet. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is

specified before any single piano exists. The piano manufacturer also employs piano technicians who are responsible for inspecting the

instruments before they are shipped to the customers. Each piano is inspected by at least one technician (identified by the employee

number). For each separate inspection, the company needs to record its date and a quality evaluation grade.