Explain the concept of transitive dependency in the context of normalization.

A field depends on another field which is not the primary key
A field depends on the primary key through another non-prime attribute
A non-prime attribute depends on another non-prime attribute
A primary key depends on a non-prime attribute

Transitive dependency occurs in a relation when a non-prime attribute depends on another non-prime attribute, which, in turn, depends on the primary key. This dependency chain indicates that the non-prime attribute is indirectly dependent on the primary key through another non-prime attribute, violating the rules of normalization.

Add your answer