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 Form
B) redundancy
C) time-variance
D) partial dependencies

Question

Quizplus · Accepted Answer

Partial dependencies can occur when a table has a composite candidate key and the primary key chosen is a single attribute, leading to dependencies on part of the composite key.

If a Table Has Multiple Candidate Keys and One of Those