If A,B,C,and D are columns of the table whose composite primary key is A,B
while C and D are nonkey columns
then B -- D is a transitive functional dependency.

Question

If A,B,C,and D are columns of the table whose composite primary key is A,B
while C and D are nonkey columns
then B --> D is a transitive functional dependency.

Quizplus · Accepted Answer

B --> D is not a transitive functional dependency because there is no intermediate column between B and D that determines D, and the relationship between B and D is only through the composite primary key of A,B.

If A,B,C,and D Are Columns of the Table Whose Composite