1.

Explain Normalization and what are the advantages of it?

Answer»

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)


Discussion

No Comment Found

Related InterviewSolutions