Database Normalization

Database Normalization

Normalization

Database Normalization can be defined as the process of organization the data to reduce the redundant table data to the minimum. This process is carried out by dividing the database into two or more than two tables and defining relationship between them so that deletion, updation and insertion can be made to just one table and it can be propagated to other tables through defined relationships.

Normalization can be done for the following reason:-

To simplify the database structure so that it is easy to maintain.
To retrieve the data quickly from the database.
To reduce the need of restructuring the database when enhancement of the application required in future.

Normal Forms

The normal form can be refers to the highest normal form condition that it meets and hence indicates the degree to which it has been modified. The normal forms are:-

  • First Normal Form (INF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce- Codd Normal Form (BCNF)
  • Forth Normal Form (4NF)
  • Fifth Normal Form(5NF)

Note: –

Normalization into 5NF is considered very rarely in practice.

First Normal Form (INF)

A table is said to be in a First Normal Form (1NF) if it satisfy the below three conditions:-

1) If the columns of the table only contain atomic values (Single, indivisible).

2) Primary key is defined for the table

3) All the columns of the table are defined on the primary key.

Second Normal Form (2NF)

A table is said to be in its Second Normal Form if it satisfied the following conditions:-

1) It satisfies the condition for the First Normal Form (1NF),

2) It do not includes and partial dependencies where a column is dependent only a part of a primary key.

Third Normal Form (3NF)

A table is said to be in the Third Normal form (3NF) if it satisfy the following conditions:-

1) It should be in the 2NF

2) It should not contain any transitive dependency which means that any non key column of the table should not be dependent on another non key column.

Denormalization

Denormalization can be defined as the process of moving from higher normal form to a lower normal forms in order to speed up the database access.

Related Aticles

First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Normalization, SQL Server and tagged , . Bookmark the permalink.

24 Responses to Database Normalization

  1. siva ganesh says:

    Will you Please explain the third point in need of normalization ("To reduce the need of restructuring the database when enhancement of the application required in future." ) with practical example.
    The Explanation to all concepts are Good .
    Thank you.

  2. Pingback: Healthcare - Dental Care

  3. Pingback: DIGITAL INCOME SYSTEM REVIEW

  4. Pingback: ratu capsa

  5. Pingback: victory tailgate

  6. Pingback: Hidden wiki onion address

  7. Pingback: miami studio

  8. Pingback: fun88bet

  9. Pingback: Motivation to just do it

  10. Pingback: Drogen kaufen

  11. Pingback: Digital Income System

  12. Pingback: Sea Games 2019

  13. Pingback: situs dominoqq online

  14. Pingback: pokermas99

  15. Pingback: www.sejarawan.info

  16. Pingback: www.kompasqqq.site

  17. Pingback: www.ratucapsa1.club

  18. Pingback: lapakqq

  19. Pingback: qiuqiu99

  20. Pingback: w88idw

  21. Pingback: keo truc tuyen

  22. Pingback: เว็บแทงบอล

  23. Pingback: اخر الاخبار

  24. Pingback: vinyl truck signs

Leave a Reply