# Database Normalization

> Setting up a database so each fact is kept in one place.

**Field:** Software Development  
**Category:** Databases  
**Also known as:** Normalization, Normal Form, Normalisation

## Think of it like

Think of it like one phone book for the whole house. Change a number once, and it is right for all.

## Definition

Normalization means each fact is kept in just one place in a database. Instead of copying a customer's city into every order, you keep it in the customers table and link to it. That way, a change happens once and nothing gets out of step. The rules come in steps called normal forms, such as first, second and third. Most apps aim for third normal form.

## Example

Jack's orders table copied each buyer's address. When Lucy moved, half her orders showed the old one. Moving addresses to the customers table fixed it.

## Why it matters

Copied data drifts apart. When there is just one copy, it cannot.

## Common mistake

Splitting tables so far that every page needs ten joins. Sometimes a small copy is worth it for speed.

## Three principles

- **One fact, one place.** No copies to drift apart.
- **Link, do not copy.** Keys point to the one copy.
- **Third form is enough.** Most apps stop there.

## Related terms

- [Database Schema](https://learn.benibix.com/term/development/schema)
- [Database Table](https://learn.benibix.com/term/development/database-table)
- [Foreign Key](https://learn.benibix.com/term/development/foreign-key)
- [Relational Database](https://learn.benibix.com/term/development/relational-database)
- [Feature Scaling](https://learn.benibix.com/term/ai/feature-scaling)

## Told apart from

- [Feature Scaling vs Database Normalization](https://learn.benibix.com/compare/feature-scaling-vs-database-normalization): People hear normalization and think of one idea, and there are two. In machine learning, it means scaling number columns to a similar range. In databases, it means splitting tables so each fact is stored once. One changes the numbers. The other changes the table layout.

---

Source: https://learn.benibix.com/term/development/normalization
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
