A relation is in ______ form if every field contains only atomic values, that…
2020
A relation is in ______ form if every field contains only atomic values, that is, not lists or sets.
- A.
First normal
- B.
Third normal
- C.
Second normal
- D.
Fourth normal
Attempted by 311 students.
Show answer & explanation
Correct answer: A
The correct option is A (First normal).
By definition, a relation is in the First Normal Form (1NF) if and only if the domain of each attribute contains only atomic (indivisible) values. It strictly prohibits multi-valued attributes, composite attributes, or non-atomic collections like lists and sets within a single field.