The following table 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
Deliverable:
Draw a dependence diagram. There are examples in the reading assignments of dependence diagrams.
In what normal form is this table? Explain why.
Decompose the table into a set of 3NF tables. Describe the process to decompose the table.
Draw an ER diagram based on the decomposed tables (in Chen model).
Table: Grade Report
Student_ID -> Student_Name, Major
Course_ID -> Course_Title, Instructor_Name, Instructor_Location
Student_ID, Course_ID -> Grade
Instructor_Name -> Instructor_Location
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