Description
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.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Running head: DATABASE SYSTEMS
1
Name
Institution
Course name
DATABASE SYSTEMS
2
1. Dependencies
Part A
Partial dependency
STU_NUM
STU_LNAME
STU_MAJOR
STU_GPA
STU_HOURS
STU_CLASS
Transitive dependency
STU_NUM -> STU_LNAME, STU_MAJOR, STU_GPA, STU_HOURS, STU_CLASS
Partial ...