Normalization
Abstract
Normal forms are how we set up correct relations among tables in RDBMS.
Keywords
Normal forms
Dr. E.F. Codd
Codd's 12 rules
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Elementary Key Normal Form (EKNF)
Boyce-Codd Normal Form (BCNF)
Fifth Normal Form (5NF)
Domain-Key Normal Form (DKNF)
Non-Normal Form Redundancy
Attribute Splitting
The Relational Model and the Normal Forms of the Relational Model were first defined by Dr. E.F. Codd (1970) then extended by other writers after him. He invented the term “normalized relations” by borrowing from the political jargon of the day. A branch of mathematics called relations deals with mappings among sets defined by predicate calculus from formal logic. Just as ...
Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
