- The relation has to be in 2nd normal form.
- Remove all transitive dependencies – a non-key attribute may not be functionally dependent on another non-key attribute
- Eliminate all dependent attributes in transitive relationship(s) from each of the tables that have a transitive relationship
- Create new table(s) with removed dependency.
- Check new table(s) as well as table(s) modified to make sure that each table has determinant and that no table contains inappropriate dependencies
Student (Studentno, student_name, major)
Course_Grade (Studentno, course_no, grade)
Instructor (Instructor_no, instructor_name, instructor_location)