A table is in first normal form when it is
A)free of repeating group data
B)free of transitive dependencies
C)free of partial dependencies
D)free of update anomalies

Question

Quizplus · Accepted Answer

First normal form (1NF) requires that each attribute in a table must have atomic values, i.e. no repeating or nested groups. Therefore, option A, which states that a table should be free of repeating group data, is the correct choice.

Transitive and partial dependencies are concerns for achieving higher normal forms, such as second and third normal form, respectively. Update anomalies are related to data inconsistencies that occur when a table is not properly normalized, but they are not specific to achieving first normal form.

A Table Is in First Normal Form When It Is