Using the STUDENT un-normalized table structure , do the following: Write the re

Using the STUDENT un-normalized table structure , do the following: Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies. Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest practical 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. Perform logical design from 3NF dependency diagram- define entities, attributes, primary keys, foreign keys, and draw the ERD using Crow’s Foot notation . Perform physical design- define data types, add/modify columns as appropriate, create DDL to create tables, primary and foreign keys. Add check constraints, not null constraints, default values as appropriate. Use Oracle supported datatypes. You do not have to implement in the database. In lab4, you will implement physical design in Oracle database. Submission: A MS word file for step 1,2, and 4 and a Visio, Word, or PDF file for step 3 Note: You do not have to test your DDL in Oracle database.