A depends on B and B depends on C,thus A implies C.If C is a candidate key and B is not a candidate key,this is a(n)________.
A)transitive dependency
B)determinate
C)partial dependency
D)atomic record

Question

Quizplus · Accepted Answer

This is an example of transitive dependency, where A depends on B and B depends on C, therefore A is indirectly dependent on C. If C is a candidate key and B is not, it means that B is functionally dependent on C and thus violates 2NF. Therefore, to eliminate the transitive dependency and achieve 2NF, B should be a candidate key or C should be split into separate entities.

A Depends on B and B Depends on C,thus a Implies