Category Archives: SQL Normalization

SQL Normalization

Boyce – Codd Normal Form (BCNF)

Boyce – Codd Normal Form (BCNF)  :- A normal form is said to be a Boyce – Codd Normal Form if it is in 3NF and there is not a possibility of a key attribute is determined by a Non Key attribute. … Continue reading

Posted in SQL Normalization, SQL Server | Tagged , | 8 Comments

Second Normal Form (2NF)

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 any partial dependencies where a … Continue reading

Posted in SQL Normalization, SQL Server | Tagged , , | 36 Comments

Third Normal Form (3NF)

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 … Continue reading

Posted in SQL Normalization, SQL Server | Tagged , | 46 Comments

First Normal form (INF)

First Normal Form (INF) A table is said to be in a First Normal Form (1NF) if it satisfy the following conditions:- 1)If the columns of the table only contain atomic values (Single, indivisible). 2)Primary key is defined for the … Continue reading

Posted in SQL Normalization, SQL Server | Tagged , | 13 Comments

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 … Continue reading

Posted in SQL Normalization, SQL Server | Tagged , | 24 Comments