Database Design 2nd Edition pp67

UNF:
Student_Grade_Report (StudentNo, StudentName, Major, CourseNo, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade)

1NF: There are no columns containing lists of data and no fields representing the same data.
Student_Grade_Report (StudentNo, StudentName, Major, CourseNo, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade)

2NF:
Student (StudentNo*, StudentName, Major)
StudentCourse (StudentNo*, CourseNo*, Grade)
CourseInstructor (CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation)

3NF:
Student (StudentNo*, StudentName, Major)
CourseGrade (StudentNo*, CourseNo*, Grade)
Course (CourseNo*, CourseName, InstructorNo)
Instructor (InstructorNo*, InstructorName, InstructorLocation)


UNF:
Student_Grade_Report (StudentNo, StudentName, Major, CourseNo, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade)

3NF: Logic: only one instructor per course.
Student (StudentNo*, StudentName, Major)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, InstructorNo@)
Instructor (InstructorNo*, InstructorName, InstructorLocation)

BCNF/4NF: Logic: multiple instructors per course, Instructors may move to teach another course.
Student (StudentNo*, StudentName, AdvisorNo@)
Student_Advisor (StudentNo*, AdvisorNo*@)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, )
Course_Instructor (CourseNo*@, InstructorNo@, InstructorLocation)
Instructor (InstructorNo*, InstructorName)
Advisor ( AdvisorNo, MajorNo@, InstructorNo*@)
Major (MajorNo*, Major)

Student (StudentNo*, StudentName)
Student_Advisor (StudentNo*, InstructorNo(Advisor)*@)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, )
Course_Instructor (CourseNo*@, InstructorNo@, InstructorLocation)
Instructor (InstructorNo*, InstructorName, MajorNo@)
Major (MajorNo*, Major)