Which 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

Quizplus · Accepted Answer

This condition is specifically defined in 3NF, where tables are required to be in both 2NF and have the additional condition that no non-key attributes (i.e., attributes that are not part of any candidate key) are dependent on any other non-key attributes. This helps to eliminate transitive dependencies and improve data consistency and normalization. 1NF and 2NF do not have this additional condition, while 4NF and higher are less commonly used and may not be necessary for all database designs.

Which Normal Form Has an Additional Condition That the Only