At this stage there should be no anomalies in 3rd normal form.
Lets look at the dependency diagrams for this example.
The first step is to remove repeating groups. As discussed above.
Student (Student_no, student_name, major)
Student_Course (Studentno, course_no, course_name,instructor_no,instructor_name, instructor_location, grade)
To recap the normalization process for the School database, the following dependencies are shown in the diagram:
PD – Partial Dependency
TD – Transitive Dependency
FD – Full Dependency