What are all the different Normalization in DBMS?

Total Post:15

Points:75
 192  View(s)
Ratings:
Rate this:
  1. Post:15

    Points:75
    What are all the different Normalization in DBMS?

    The normal forms can be divided into 5 forms, and they are explained below -

    First Normal Form (1NF):.  It should remove all the duplicate columns from the table. The creation of tables for the related data and identification of unique columns.

    Second Normal Form (2NF):. First fulfill all the requirements of normal form. Creating subsets and relationships of data in different tables between tables using primary keys.

    Third Normal Form (3NF):.

    It should meet all requirements of 2NF. Removing the columns which are not dependent on primary key constraints.

    Fourth Normal Form (3NF):.

    Complete all the requirements of the third normal form and it should not have multi-dependent dependencies.

  1. Post:9

    Points:45
    What are all the different Normalization in DBMS?

     Different Types of Normalization are:

    First Normal Form (1NF): The relation is said to be in 1NF only when all the entities of the table contain unique or atomic values.

    Second Normal Form (2NF): The relation is said to be in 2NF only if it is in 1NF and all the non-key attribute of the table is fully dependent on the primary key.

    Third Normal Form (3NF): The relation is said to be in 3NF only if it is in 2NF and every non-key attribute of the table is not transitively dependent on the primary key.

Answer