Using Microsoft Word, complete the following:
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).
