Normalization is a method for data design and organizing the data which is applied to the data structures. It is a step by step approach of dividing tables to eliminate data redundancy and removing undesirable characteristics like Insertion, modifications and Deletion Anamolies. Normalization is a multi-step process that puts data in the form of a table, thus removing duplicated data from the relation tables.
Normalization is used for achieving two main purposes,
- Removing redundant data.
- Ensuring data is stored logically