Database Normalization

SQL Normalization SQL Server

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)

31 thoughts on “Database Normalization

  1. 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: ratu capsa
  3. Pingback: victory tailgate
  4. Pingback: miami studio
  5. Pingback: fun88bet
  6. Pingback: Drogen kaufen
  7. Pingback: Sea Games 2019
  8. Pingback: pokermas99
  9. Pingback: www.sejarawan.info
  10. Pingback: www.kompasqqq.site
  11. Pingback: lapakqq
  12. Pingback: qiuqiu99
  13. Pingback: w88idw
  14. Pingback: keo truc tuyen
  15. Pingback: vinyl truck signs
  16. Pingback: Constellations
  17. Pingback: kompas qq
  18. Pingback: wede qq
  19. Pingback: elangqq login
  20. Pingback: vao w88

Leave a Reply