Update anomalies in 3rd normal form

Available under Creative Commons-ShareAlike 4.0 International License.

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:

Figure 12.1

 

PD – Partial Dependency

TD – Transitive Dependency
FD – Full Dependency