A ____ exists when there are functional dependencies such that Y is functionally dependent on X and 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

A transitive dependency exists when there are functional dependencies such that Y is functionally dependent on X and Z is functionally dependent on Y, but there is no direct functional dependency between X and Z. In this case, X is the primary key, and there is a transitive dependency between X and Z through Y, violating the second normal form (2NF) of database normalization.

A ____ Exists When There Are Functional Dependencies Such That