Databases Intermediate

What is Normalization?

The process of organizing database tables to reduce data redundancy and improve data integrity.

Normalization structures a database into normal forms (1NF through 5NF, typically up to 3NF). First Normal Form eliminates repeating groups. Second Normal Form removes partial dependencies. Third Normal Form removes transitive dependencies.

Benefits include reduced data duplication, consistent updates, and smaller tables. Trade-offs include more JOINs and potentially slower reads. Denormalization intentionally adds redundancy for read performance.

Learn More About This Topic

Database Design & Modeling Fundamentals

Closely related

SQL for Absolute Beginners

Related reading

Redis Fundamentals

Related reading

Related Terms

Database Sharding

A horizontal scaling strategy that distributes data across multiple database servers based on a partition key.

Window Function

An SQL function that performs calculations across a set of rows related to the current row without collapsing the result set.

A set of four properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions.

Stored Procedure

A precompiled collection of SQL statements stored in the database that can be executed as a single unit.

A technique of dividing large database tables into smaller, more manageable segments while maintaining a single logical table.

The default index type in most databases that organizes data in a balanced tree structure for efficient searching, sorting, and range queries.

View All Databases Terms →