Normalization is a process for converting complex data structures into simple, stable data structures.Why normalisation is necessary ?

The database design must be efficient (performance-wise).
The amount of data should be reduced if possible.
The design should be free of update, insertion and deletion anomalies.
The design must comply with rules regarding relational databases.
The design has to show pertinent [...]

→ Read the article

Chapter Objectives
At the end of the chapter, you should be able to:

understand the purpose of normalization;
perform first, second and third normalization;
merging relations (view integration);
transforming E-R diagrams to relations.

Essential Reading

Modem Database Management (4th Edition), red R. Mcfadden & Jeffrey A. Hoffer (1994),
Benjamin/Cummings.[Chapter 6, page 199 - 237]

→ Read the article