Type the 3NF decomposition of GRADE_REPORT

Answer

STUDENT(StudentID, StudentName, CampusAddress, Major) COURSE(CourseID, CourseTitle, InstructorName) INSTRUCTOR(InstructorName, InstructorLocation) REGISTRATION(StudentID, CourseID, Grade)

Each determinant (StudentID, CourseID, InstructorName, and the composite key) became one relation. InstructorName in COURSE is a FK to INSTRUCTOR; StudentID and CourseID in REGISTRATION are FKs to STUDENT and COURSE.