Category Archives: SQL Normalization

SQL Normalization

Second Normal Form (2NF)

By | January 26, 2010

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 column is dependent only a part of a primary key. For example suppose we have… Read More »

Database Normalization

By | January 26, 2010

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… Read More »