For each of the descriptions below, perform the following tasks:i) Identify the degree and cardinalities of the relationship. ii) Express the entities and the relationships with attributes in each description graphically with an E-R diagramA 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. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists.