Using the table structure shown in Table P6.4, do the following:
1.Write the relational schema, draw its dependency diagram, and identify all dependencies, including all transitive dependencies.
2.Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest extent possible. If you believe that practical considerations dictate using a 2NF structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions.
3.Draw the Crow’s Foot ERD.