Normalisation is a way to validate and improve logical design of a relational database to reduce redundancy and enhance data integrity. It is the process of decomposing relations with anomalies to produce smaller, well-structured relations.
Reference
- Hoffer, J. A., (2019). Modern database management. 12th ed. Upper Saddle River, N.J: Prentice Hall.