Available under Creative Commons-ShareAlike 4.0 International License.
- 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)
Course (Course_no,course_name,instructor_no)
Instructor (Instructor_no, instructor_name, instructor_location)
- 10204 reads
