What is Normalization? explain all the normal forms.
by Nirmala[ Edit ] 2010-04-07 09:16:46
Normalization :
The process of decomposing tables to eliminate data redundancy is called Normalization.
1 N.F:- The table should caontain scalar or atomic values.
2 N.F:- Table should be in 1N.F + No partial functional dependencies
3 N.F :-Table should be in 2 N.F + No transitive dependencies