WHAT IS NORMALIZATION?? Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables. Normalization is used for mainly two purpose, Eliminating redundant(useless) data. Ensuring data dependencies make sense i.e data is logically stored NORMALIZATION RULE Normalization rule are divided into following normal form. First Normal Form Second Normal Form Third Normal Form BCNF Below is a basic example of normalization upto third normal form which I did as part of my class assignment. Normalization Slides