Transitive dependency:
When any non-prime attribute is determine another non prime attribute then this is called as transitive dependency.
Example:
table have A,B,C,D attribute
candidate key is: AB
where, A and B is the prime attribute.
and C and D is the Non prime attribute
and ,
C -> D
-Here C is define the D attribute then this type of dependency is called as transitive dependency.
Read More →