Course contentsShow
← Computer Science
Lesson 1632 of 2,87237. Database Design and NormalizationFree lesson

First Normal Form (1NF) Definition

Defining 1NF requirements: atomic values, no repeating groups, and each cell containing single values.

First Normal Form (1NF) Definition

What you'll learn: You'll understand the three core requirements that make a table satisfy First Normal Form (1NF), the foundation of database normalization.


Now that you've learned about normal forms in general, let's define the first and most basic one: First Normal Form (1NF).

What is 1NF?

A table is in First Normal Form when it satisfies three fundamental requirements:

  1. Atomic values only – Each cell must contain a single, indivisible value
  2. No repeating groups – No columns should repeat (like Phone1, Phone2, Phone3)
  3. Single value per cell – Each intersection of row and column holds exactly one value

Why Does This Matter?

Think of a table like a filing cabinet where each drawer (row) has labeled folders (columns). If you stuff multiple documents into one folder label, or create a dozen folders all called "Phone Number," you'll have chaos when searching or updating.

Example of violations:

Employee table (NOT in 1NF):
| EmployeeID | Name  | PhoneNumbers         |
|------------|-------|----------------------|
| 101        | Alice | 555-1234, 555-5678  |
| 102        | Bob   | 555-9999            |

The PhoneNumbers column violates atomicity—it contains two values separated by a comma.

Corrected to 1NF:

| EmployeeID | Name  | PhoneNumber |
|------------|-------|-------------|
| 101        | Alice | 555-1234    |
| 101        | Alice | 555-5678    |
| 102        | Bob   | 555-9999    |

Now each cell contains exactly one atomic value, with no repeating column groups and no multi-valued cells.


Key Takeaway: First Normal Form (1NF) requires atomic values in every cell, eliminates repeating column groups, and ensures each cell contains only a single value—creating a clean foundation for further normalization.