Chapter 4. The Normalization Process
In this hour, you learn the process of taking a raw database and breaking it into logical units called tables. This process is referred to as normalization. The normalization process is used by database developers to design databases in which it is easy to organize and manage data while ensuring the accuracy of data throughout the database.
The advantages and disadvantages of both normalization and denormalization of a database are discussed in this hour, as well as data integrity versus performance issues that pertain to normalization.
The highlights of this hour include:
What normalization is
Benefits of normalization
Advantages of denormalization
Normalization techniques
Guidelines of normalization
The three normal ...
Get Sams Teach Yourself SQL in 24 Hours, Fourth 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.
