A transitive dependency
A)is a database condition that is resolved through special monitoring software.
B)is a name given to one of the three anomalies that result from unnormalized database tables.
C)can exist only in a table with a composite primary key.
D)cannot exist in tables that are normalized at the 2NF level.
E)is none of the above.

Question

Quizplus · Accepted Answer

A transitive dependency occurs when a non-prime attribute depends on another non-prime attribute rather than directly on the primary key. In 2NF, all non-prime attributes must depend only on the primary key, thus eliminating transitive dependencies.

A Transitive Dependency