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.