- It is a rule where larger tables are divided into smaller tables and they are linked using relationships.
- Process of organizing data in a data base is called as Normalization.
- The purpose of Normalisation is to eliminate repetitive data and ensure that data is stored logically.
- Normalization minimizes redundency from a relation or relation set.
- Normalization also helps in minimizing Reuse of data.
- Also helps in reduction of insertion, updation and deletion anamolies.
- Relation schemas that do not meet the properties are decomposed into small relation schemas so that they can meet the desired properties.
- It is a rule where larger tables are divided into smaller tables and they are linked using relationships.
- Database table redundancy is reduced by using normal forms.
