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 3NF level.
E) is none of the above.

Question

Quizplus · Accepted Answer

Transitive dependency is a kind of dependency in a database that is eliminated when a database is normalized to the Third Normal Form (3NF). This means that in tables that are normalized at the 3NF level or higher, transitive dependencies are resolved to prevent anomalies and ensure data integrity.

A Transitive Dependency