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:
- Atomic values only – Each cell must contain a single, indivisible value
- No repeating groups – No columns should repeat (like Phone1, Phone2, Phone3)
- 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.