Browse Teach Curate

Database Normalization

Normalization decomposes tables so each fact is stored once, keyed by its identifier, eliminating update and deletion anomalies. Its practical cost is that queries must join the decomposed tables back together.

Questions this Concept answers

Why does storing the same fact in many rows create a risk beyond wasted space?

jeremy Video

Relational Database Normalization From 1NF to 5NF

Database normalization is a theory within relational database design that defines a hierarchy of criteria, called normal forms, which a table's structure must satisfy to prevent redundant and self-co…