What is Normalization in Database ?

0 votes
315 views
Sanat Shukla asked 21-Sep-2018 in Database by Sanat Shukla

Why Normalization concept is used in the database.

1 Answer

0 votes
Arti Mishra answered 18-Nov-2018 by Arti Mishra

“Normalization in Database”

Normalization is a process of organizing the huge amount of data into a database and reduces the dependency of relation table. It divides the large table into multiple sub-parts and links them as a relation. 


Types of Normalization
  •  First normal form(1NF)
  •  Second normal form(2NF)
  • Third normal form(3NF)
  • Boyce & Codd normal form (BCNF)
  •  Fourth normal form(4NF)
  • Fifth normal form(5NF)

First Normal Form(1NF) :
1NF describe the concept of atomic value, I mean an attribute of a column can’t have multiple values.

What is  Normalization in Database ?


Second Normal Form(2NF) :
A table is said to be in 2NF if follow these conditions-
Table must follow the rule of 1NF (First normal form) and all attributes are dependent on a primary key attribute.

What is  Normalization in Database ?


Third Normal Form (3NF) :
In 3NF, a table must follow the rule of 2NF and no any transitive dependency will exist.

What is  Normalization in Database ?


Boyce & Codd normal form (BCNF) :
BCNF is the extension of 3NF and for every functional dependency A->B, A should be the super key of the table.

What is  Normalization in Database ?


Fourth Normal Form(4NF) :
In 4NF, a table must follow the rule of BCNF and no any multi-valued dependency will exist.

What is  Normalization in Database ?
What is  Normalization in Database ?

Fifth Normal Form (5NF) :
In 5NF, a table must follow the rule of 4NF and no any join dependency will be allowed.

What is  Normalization in Database ?



"Thanks!!! for Reading"