A(n) ____ 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

This is a transitive dependency because there is a chain of functional dependencies linking X to Z. X → Y (Y depends on X), and Y → Z (Z depends on Y), so X → Z (Z depends on X) through the transitive dependency of Y.

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