For each of the descriptions below, perform the following tasks; Follow guidelines for data names and data definitions Explain why you use either mandatory or optional relationship constrains Identify relationships attributes Draw E-R diagram in Lucidchart and provide shared Read-Only link to it For each E-R diagram create and 3 data definition tables using the following templates:

1.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. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists. (30p)