Normalizing a Database
Normalization is the process of reducing the repetition and redundancies of data in a database. Didn't we already say that? If we were to normalize the first sentence in this paragraph, it might read, “Normalization is the process of reducing redundant information in a database.”
The Raw Database
When you begin designing a database, or migrating a database from one implementation to another, you may find yourself staring at a massive collection of data. All of your data is there, but it is not in a manageable order. A database that is not normalized may contain data that resides in one or more different tables for no apparent reason. This could be bad for security reasons, disk space use, speed of queries, efficiency of ...
Get Sams Teach Yourself SQL in 21 Days, 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.
