The process of organizing the data to minimize the redundancy is called Normalization. The process of organizing the data to minimize the redundancy is called Normalization. The objective to isolate data so that addition, deletion and modifications of field can be made in just in one table and then propagate through the rest of database via define relationship.
There are numerous Normal Forms to design as an effective Database. Below are few:
1. 1NF (First Normal Form):
Purpose of 1NF is Eliminate Repeating Group. Make a separate table for each set of related attributes and give each table a Primary Key.
2. 2NF (Second Normal Form):
It states to Eliminates Redundant Data. If any attribute is dependent on part of multi-valued key, remove it to separate table.
3. 3NF (Third Normal Form):
Eliminates columns that are not dependent on key.
4. BCNF (Boyce Code Normal Form):
Non-Trivial dependencies between candidate key attributes should separate them out to a new table.
5. 4NF (Fourth Normal Form):
Isolate multiple independent relationships.
6. 5NF (Fifth Normal Form):
Isolate semantically Relate multiple Relationship.
7. ONF (Optimal Normal Form):
A model is limited to only simple facts, as expressed in Object Role Model Notation.
8. DKNF (Domain Key Normal Form):
A model is free from all modification anomalies is said to be DKNF.
