Which of the following best describes a transitive dependency?
A) A transitive dependency exists when a nonkey data element depends on a primary key data element.
B) A transitive dependency exists when a nonkey data element depends on another nonkey data element.
C) A transitive dependency exists when a primary key data element depends on another primary key element.
D) A transitive dependency exists when a primary key data element depends on a nonkey element.

Question

Quizplus · Accepted Answer

A transitive dependency in database theory occurs when a nonkey attribute depends on another nonkey attribute, which in turn depends on a key attribute. This can lead to redundancy and anomalies in the database.

Which of the Following Best Describes a Transitive Dependency