GradeReport (StudentID, StudentName, StudentAddress, StudentMajor, CourseID, CourseName, InstructorID, InstructorName, InstructorOffice, Grade)

In this table:

There is no repeating group.

Each student has a student ID that uniquely identifies the student.

Each course has a course ID that uniquely identifies the course.

Each instructor has an instructor ID that uniquely identifies the instructor.

Each student can only have one major.

Each student can only have one address.

Each course can only be taught by one instructor.

Each instructor has only one office.

Using the GradeReport table structure above, do the following:

a. Determine the primary key of the table, draw its dependency diagram and identify all

dependencies, including all partial and transitive dependencies.