Loading…

Explain Normalization and what are the advantages of it?

It is a systematic approach of decomposing tables to remove data redundancy and undesirable characteristics like Insertion, Update and Deletion. Normalization is a multi-step process that put data into the tabular form and removing duplicated data from the tables.

Advantages
  • It helps to the reduction of redundant data.
  • It has a much more flexible database design.
  • It is better to handle on database security.
  • It is dealing with data consistency within the database.
Rule of Normalization
  • 1NF(First Normal Form)
  • 2NF(Second Normal Form)
  • 3NF(Third Normal Form)
  • BCNF(Boyce and Codd Normal Form)
  • 4NF(Fourth Normal Form)

Suggest An Answer

No suggestions avaliable!

Latest post from SQL Interview Questions

Ask Question