A table in second normal form should be improved to third normal form because _____.
A) its determinants can cause update anomalies
B) its candidate keys can cause update anomalies
C) this reduces the number of relations in the database
D) this eliminates repeating groups that waste space

Question

Quizplus · Accepted Answer

In third normal form (3NF), a table is in 2NF and all of its columns are non-transitively dependent on the primary key, which helps eliminate update anomalies caused by functional dependencies (determinants).

A Table in Second Normal Form Should Be Improved to Third