Topics: Database

In databases, we say that a relation (table) has a transitive dependency if, for three distinct sets of attributes , and we have that:

  1. ( is functionally dependant on )
  2. ( is not functionally dependant on )

The resulting functional dependency is what we call a transitive dependency. Normally we’ll refer to transitive dependencies where is a candidate key (or primary key).

Transitive dependencies are to be avoided if we want to have a relation in the third normal form.