Transitive+Dependency+Definition

If the value in a non-key attribute is determined by the value in another non-key attribute then that field has transitive dependency.

For example, look at the relation below:

The attribute **teacher_name** is determined by the non-key attribute **teacher_id**, and not the primary key of **course_id**. This means that teacher_name is transitively dependent on the primary key of course_id.

In order to show a relation in 3NF, all transitive dependencies must be removed.