Database hw

Consider the following data structure GRADEREPORT (Student ID, Student Name, Major, Course ID, Course Title, Instructor ID, Instructor Name, Grade) Some clarifications: Student ID is a unique identifier for student and serves as the determinant for Student Name and Major. Course ID is a unique identifier for a specific section of a course and serves as the determinant for Course Title, Instructor ID and Instructor Name. Instructor ID is a unique identifier for instructor and serves as the determinant for Instructor Name. Answer the following questions: Identify all the functional dependencies in this relation (Full dependencies, partial dependencies, transitive dependencies). In what normal form is this data structure? Justify your answer. Convert this data structure to a set of 3NF relations. Clearly showing each step.