Normalisation

Normalisation: is a process used in the design of a database, whereby we attempt to minimise data redundancy (duplication) of data by breaking the database up into a number of smaller linked tables. Databases that have been completely normalised do not have any integrity issues because their structures prevent redundant data from being stored.