For the structure shown in the table below, answer the following questions: In your group, you will need to submit the following for the above given ER diagram: 1. Write the relational schema and draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not in Third Normal Form, explain why. Discuss PK and FK for each relation. (Also make sure that the new dependency diagram contains attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so) 2. Draw the Crow's Foot ERD. 3. Relational data structures that translates the above ER diagram, which includes: a. relation names, b. attribute names and field types c. primary keys identified Sample Data Dictionary c. primary keys identified Sample Data Dictionary Table 3.6 A Sample Data Dictionary \begin{tabular}{l|l} \hline FK & = Foreign key \\ \hline PK & = Primary key \\ \hline CHAR & = Fixed character length data (1- 255 characters) \\ \hline VARCHAR & = Variable character length data (1- 2,000 characters) \\ \hline NUMBER & =Numericdata.NUMBER(9,2)isusedtospecifynumberswithuptoninedigits,includingtwodigitstotherightofthededimalplace.SomeRDBMSsuseNUMERICorDECIMALinsteadofNUMBER,andotherspermittheuseofaMONEYorCURRENCYdatatype. \end{tabular} Team contribution statement The group should also complete the Student Contribution table for this stage of the Assignment and submit it along with your E-R diagram to the Stage 2 Dropbox