Third Normal Form prohibits transitive dependencies. A transitive
dependency exists when any attribute in a table is dependent on
any other non-key attribute in that table.
Consider the following example CourseSections Table:
professor is uniquely identified by the CourseID and Section of the
course. However, ProfessorName depends on ProfessorID and has no
relation to CourseID or Section.
data is properly stored as follows:
splitting the data into two tables, the transitive dependency is
the original design of the CourseSections table introduces the
chance that ProfessorName may be Corrupted. Perhaps, on the second row
the ProfessorName is entered as Davif, a simple typo. Since there is
no such professor Davif, there would be a problem.
Original date of publication, 02/21/2001