A candidate key must satisfy all of the following conditions EXCEPT:
A) the key must uniquely identify the row.
B) the key must indicate the row's position in the table.
C) the key must be nonredundant.
D) each nonkey attribute is functionally dependent upon it.

Question

Quizplus · Accepted Answer

A candidate key does not need to indicate the row's position in the table; it only needs to uniquely identify each row and be nonredundant, with all nonkey attributes functionally dependent on it.

A Candidate Key Must Satisfy All of the Following Conditions