Why Normalise Data?
A definition of Normalisation is: “In relational database design, the process of Normalisation is organising table data to minimise duplication…” “Normalisation involves dividing a database into 2 or more tables and defining relationships between the tables. The objective of normalisation is to isolate data so that additions, deletions and modifications of data fields can be made in just one table and then propagated (spread) through the rest of the database using pre-defined relationships.” source – Webopedia, http://www.webopedia.com/TERM/n/normalization.html Another Definition – “Normalisation is the process of creating an…
