Question 21 Not yet answered Marked out of 12.00 p Flag question Describe the ER Diagram for the following organization. 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 planos 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 planos 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