A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.
A) partial dependency
B) repeating group
C) atomic attribute
D) transitive dependency

Question

Quizplus · Accepted Answer

This is an example of a transitive dependency, where an attribute (Z) is functionally dependent on another non-key attribute (Y), which in turn is functionally dependent on the primary key attribute (X).

A(n) _____ Exists When There Are Functional Dependencies Such That