A table is in the third normal form if the table is in the second normal form and ________.
A) contains no repeating groups
B) has two foreign keys
C) no non-key attribute is dependent on another non-key attribute
D) none of the above

Question

Quizplus · Accepted Answer

A table is in the third normal form if it is in the second normal form and no non-key attribute is dependent on another non-key attribute. This ensures that all attributes are directly dependent on the primary key, eliminating transitive dependencies.

A Table Is in the Third Normal Form If the Table