Which normal form requires every attribute in a relation to contain only atomic values?
Options
-
A.
First Normal Form (1NF)
-
B.
Second Normal Form (2NF)
-
C.
Third Normal Form (3NF)
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
A.
First Normal Form (1NF)
Detailed Explanation
- First Normal Form (1NF): Requires each attribute to contain atomic values.
- Each cell should contain a single value rather than a repeating group or multivalued field.
- It is the basic requirement for relational normalization.