Database Normalization
Subject: Computer and Technology noun /ˈdeɪ.təˌbeɪs ˌnɔːr.mə.ləˈzeɪ.ʃən/ 1 definition
- database-systems
- relational-databases
- data-modeling
- schema-design
-
Definition (noun)
Entry #66 · UpdatedDatabase Normalization is the systematic process of structuring a relational database schema into well-defined tables and relationships governed by functional dependencies and primary and foreign key constraints. By decomposing overly broad tables so each table models a single entity or relationship, it eliminates duplicate storage and prevents insertion, update, and deletion anomalies that compromise data integrity. While higher normal forms safeguard consistency across transactional writes, analytical and read-heavy systems sometimes selectively denormalize schemas to avoid multi-table join overhead.
Common Forms
First Normal Form (1NF): Requires every table column to hold only atomic values with no repeating groups or multi-valued attributes, ensuring each row is uniquely identifiable.
Second Normal Form (2NF): Builds on 1NF by eliminating partial dependencies, ensuring every non-key attribute depends on the whole key rather than only part of a composite candidate key.
Third Normal Form (3NF): Builds on 2NF by removing transitive dependencies so non-key columns depend directly on a candidate key rather than indirectly on other non-key attributes.
Boyce-Codd Normal Form (BCNF): Strengthens 3NF by requiring that the determinant of every non-trivial functional dependency is a superkey, resolving edge-case anomalies involving overlapping composite candidate keys.
Example
An e-commerce application initially stores
order_id,customer_name,customer_email, andorder_totaltogether in a singleorderstable, duplicating customer contact details on every purchase and risking stale records when an email changes. Normalizing the schema to Third Normal Form movescustomer_nameandcustomer_emailinto acustomerstable linked by acustomer_idforeign key, ensuring each customer's email is stored once and updated in a single place.