What is normalization?
Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships.
Why Normalization required?
Normaliztion is required for avoiding
a)Delete Anomalies -:If deletion of any record will be done then all references of that records should be deleted
b)Update Anomalies -:If updatation of any record will be done then all references of that records should be updated
c)Data Redundancy -: Avoiding data repeatation .
Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database using the defined relationships.
Why Normalization required?
Normaliztion is required for avoiding
a)Delete Anomalies -:If deletion of any record will be done then all references of that records should be deleted
b)Update Anomalies -:If updatation of any record will be done then all references of that records should be updated
c)Data Redundancy -: Avoiding data repeatation .
