Importance of Normalization

Database normalization is the process of organizing the attributes of database to reduce or eliminate Data Redundancy (having same data but at different places) .

 

aquad website useful links

We can design database without the normalization process, that is, without any organized way to design database. Such designs lack the standards and hence we cannot evaluate the database design. Normalization provides a systematic approach to determining a table’s structure

 

Normalization ensures that attributes are grouped together in such a way that there is no redundancy or at least controlled redundancy.If we have data redundancies, then data in the database can create problems when we update the data. Such problems can lead to data inconsistencies, data integrity issues, and data update (add, insert, delete) anomalies. The bottom line is “each table should have only one source of data” if it is in the normal form.

Leave a Reply

Your email address will not be published. Required fields are marked *