Academic help online
The following information shows a table called Grade Report for a university. The existing functional dependencies are described as follows:
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
Student_ID
Student_ Name
Major
Course_ID
Course_Title
Instructor_Name
Instructor_Location
Grade
168300458
Williams
IT
ITD320
Database Imp
Codd
B104
A
168300458
Williams
IT
ITP310
Programming
Parsons
B317
B
543291073
Baker
Acctg
ITD320
Database Imp
Codd
B104
C
543291073
Baker
Acctg
Acct201
Fund Acctg
Miller
H310
B
543291073
Baker
Acctg
Mktg300
Intro Mktg
Bennett
B212
A
Assignment Guidelines:
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.