Skip to main content
Definition Website Computer and Technology

Database Normalization

Subject: Computer and Technology noun /ˈdeɪ.təˌbeɪs ˌnɔːr.mə.ləˈzeɪ.ʃən/ 1 definition

  1. Definition (noun)

    Entry #66 · Updated

    Database 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, and order_total together in a single orders table, duplicating customer contact details on every purchase and risking stale records when an email changes. Normalizing the schema to Third Normal Form moves customer_name and customer_email into a customers table linked by a customer_id foreign key, ensuring each customer's email is stored once and updated in a single place.