Student_ID -> Student_Name, Major
Course_ID -> Course_Title, Instructor_Name, Instructor_Location
Student_ID, Course_ID -> Grade
Instructor_Name -> Instructor_Location
Table: Grade Report
Draw a dependency diagram for the listed functional dependencies.
In what normal form is the table located within the Assignment Description? Explain why.
Split the table into a set of 3NF tables.
How did you arrive at your solution?
Draw an Entity-Relationship diagram based on your new 3NF table set.
You may use Microsoft Access for help with table splitting and drawing your diagram.
Recently Asked Questions
- Why has Zara decided to use automation for in-store pickup of items?
- Please refer to the attachment to answer this question. This question was created from CS_Chapter_20.docx.
- Kingsville Company purchased a new machine on January 1, 2017, at a cost of $75,000. The company estimated that the machine has a salvage value of $5,000 and