The Process of Normalisation is used to remove duplicate data from Database Tables. For example: Where you may have a value stored multiple times, you would need to (by using Normalisation), remove the need for duplicate Data. The best way to do this is by using a tool called an Entity Relationship Diagram. An Entity may be a physical object (such as a Customer), or a Concept (such as Payments). Using the ERD you can establish which items are likely to be duplicated, and which are to remain as single entities. The relationships between them may be, A Customer makes one or many payments. The entities form the basis of the Table, the Attributes form the other distinct data in your Database. Say the Entity was a Customer (this would become the Table), the Attributes for the Customer would be, Customer ID (in this case the Primary Key), other Attributes would be details such as Title, Forename, Surname, and any other information you wish to store about the Customer. Where you have many items they would be seperated out into another table, and a Foreign Key would be used to link the Primary Key of the one table (Customers) to the Foreign Key in the Payments Table (Customer ID).

I hope this makes sense to you?

Many thanks,

Tech