What is normalization and what are the different types of normalization?

All Questions › Category: Database › What is normalization and what are the different types of normalization?
0 Vote Up Vote Down
chetan shidling asked 4 years ago

I need short information.

2 Answers
0 Vote Up Vote Down
chetan shidling answered 4 years ago

It is a process to avoid any duplication. There are mainly four types of normalization: 1NF, 2NF, 3NF, & BCNF.
 

  1. INF – Each table cell should have a single value. So, basically, all the records must be unique.
  2. 2NF – The database should be 1NF and should also have a single-column primary key.
  3. 3NF – The database should be in 2NF and must not have any transitive functional dependencies.
0 Vote Up Vote Down
chetan shidling answered 4 years ago

It is a process to avoid any duplication. There are mainly four types of normalization: 1NF, 2NF, 3NF, & BCNF.
 

  1. INF(First normal form) – Each table cell should have a single value. So, basically, all the records must be unique.
  2. 2NF(Second normal form) – The database should be 1NF and should also have a single-column primary key.
  3. 3NF(Third normal form) – The database should be in 2NF and must not have any transitive functional dependencies.
  4. BCNF(Boyce & Codd normal form) – if your database is in 3rd normal form, there would be some scenarios where anomalies would be present, if you have more than candidate key. Then BCNF comes into role, where you divide your tables further so that there would be only one candidate key present.