A relation is in ____ if it does not contain any repeating groups.
A)first normal form
B)second normal form
C)third normal form
D)Boyce-Codd normal form

Question

A relation is in ____ if it does not contain any repeating groups.
A)first normal form
B)​second normal form
C)third normal form
D)​Boyce-Codd normal form

Quizplus · Accepted Answer

First normal form (1NF) requires that all attributes in a relation be atomic, meaning that they cannot be further divided into smaller components. This eliminates repeating groups in a relation, making A the correct answer. Second normal form (2NF) requires that a relation be in 1NF and also that all non-key attributes be dependent on the entire primary key, not just part of it. Third normal form (3NF) requires that a relation be in 2NF and also that there be no transitive dependencies between non-key attributes. Boyce-Codd normal form (BCNF) is a stricter version of 3NF that requires that every determinant be a candidate key.

A Relation Is in ____ If It Does Not Contain