Normalization

Normalization is process of splitting the base table into multiple tables based on the theory of Functional Dependency.

Or

Normalization is repetitive process in order to identify the functional dependencies among the columns and to remove them. If any functional dependency is occurred after the normalization process again we have to start the same process until all functional dependencies have been removed.

To do this Normalization we have to follow rules or conditions called Normal Forms.

Un-Normalized Table:

EmpNo=11
ProjNo=p1,p2
EName=-----
PName=Pn1,Pn2
Sal =-----
Bud=------
DeptNo=10
Dname=------
Loc=------

EmpNo and ProjNo are Primary keys called 'COMPOSITE PRIMARY KEY'

Normalization