Normalisation

Normalization -is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies--that could lead to a loss of data integrity.