What is Normalization in SQL ?

  • 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.

Leave a Reply

Your email address will not be published.

You May Also Like