Following are the major advantages of normalization:
Because information is logically kept together, normalization provides improved overall understanding of the system.
Because of controlled redundancy of data, normalization can result in fast table scans and searches (because less physical data has to be processed).
Because tables are smaller with normalization, index creation and data sorts are much faster.
With less ...