5.1. Normalization
In relational database theory, five normal forms are defined. Normal forms represent a guideline for record design and are essential when building complex data structures. They can be used to prevent inconsistencies and anomalies in the data and will help you to build clear and efficient data structures. In this book normal forms will only be covered very briefly because normalization can be a complicated subject if you want to build data models that satisfy all demands of the fifth normal form.
5.1.1. The First Normal Form
In the first normal form, all records in the table must have the same number of columns and all columns have to be the same data type. Every name of a field has to be unique within a table. The relational ...
Get PHP and PostgreSQL: Advanced Web Programming 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.
