DB+-+Normalisation

Data Modelling and Normalisation:
 * **Normalisation is a way of stucturing the data in a database.**
 * **Normalistaion is used for data modelling.**
 * **Normalisation is a process which makes sure that the rules of the relational database model are correctly applied.**


 * Normalising is a process carried out on the entities of a database in order to make the database work more efficiently, in particular, normalising will help setting up a relational database.**


 * First Normal form (1NF).
 * To achieve 1NF, we must remove repeating groups or data (data that contains the same data).


 * The Process**;


 * 1) ===__**Identify all the data items**__===
 * 2) ===__**Identify any repeating groups**__===
 * 3) ===__**Identify the key(s)**__===
 * 4) ===__**Remove any repeating groups into separate entities**__===
 * 5) ===__**Identify keys, add foreign key(S) to represent the relationships.**__===