What are the purpose of Normalisation?
Ankur Jain
to diminish complexity
reduce the redundancy in database..............
The main purpose of normalization for remove the dependency in all joined tables and make the table more uniqueness.
Minimize redundancy in data
Minimize redundancy in data. Remove insert, delete and update anamoly during the database activities. Reduce the need to reorganize data it is modified or enhanced. Normalisation reduces a complex user view to a set of small and stable subgroups of fields or relations.