____ normal form has an additional condition that the only determinants the table contains are candidate keys.
A) First
B) Second
C) Third
D) Fourth

Question

____ normal form has an additional condition that the only determinants the table contains are candidate keys.​
A) ​First
B) ​Second
C) ​Third
D) ​Fourth

Quizplus · Accepted Answer

In Third Normal Form (3NF), a table must not contain any transitive dependencies and should be free of functional dependencies on non-key attributes. Additionally, 3NF requires that every non-key attribute be fully dependent on the primary key and not just a subset of the key. Finally, 3NF stipulates that the table should not contain any determinants other than candidate keys. This means that every non-key attribute should have a unique relationship with a candidate key, and not with any other non-key attributes or groups of non-key attributes. Therefore, option C is the best choice for the given question.

____ Normal Form Has an Additional Condition That the Only