If a table has multiple candidate keys and one of those candidate keys is a composite key, the table can have _____ based on this composite candidate key even when the primary key chosen is a single attribute.
A) Boyce-Codd normal forms
B) redundancies
C) time-variances
D) partial dependencies

Question

Quizplus · Accepted Answer

Partial dependencies can occur in a table when a composite candidate key exists, and the primary key chosen is a single attribute. This is because partial dependency happens when a non-prime attribute is dependent on part of a composite candidate key, which can lead to normalization issues.

If a Table Has Multiple Candidate Keys and One of Those