A Transitive Dependency

Multiple Choice

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.