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 -- C is a partial 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 --> C is a partial functional dependency.

Quizplus · Accepted Answer

According to the given statement, the composite primary key is A,B which means both A and B together uniquely identify each row in the table. However, we also know that C and D are non-key columns, meaning their values do not contribute to the uniqueness of the row. Therefore, if B determines C, it is a partial functional dependency because C is dependent on only a part of the composite primary key (B), not the whole key (A,B).

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