Benefits of Normalization
Normalization provides numerous benefits to a database. Some of the major benefits include
Greater overall database organization
The reduction of redundant data
Data consistency within the database
A much more flexible database design
A better handle on database security
Organization is obtained from the normalization process, making everyone's job easier—from the user who accesses tables to the database administrator (DBA) who is responsible for the overall management of every object in the database. Data redundancy is reduced, which simplifies data structures and conserves disk space. Since duplicate data is minimized, the possibility of inconsistent data is greatly reduced. You avoid situations where one table lists an ...
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.