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).