Database Normalisation is a technique of organizing the data in the database.
Normalization is used for mainly two purpose:
1. Eliminating reduntant(useless) data.
2. Ensuring data dependencies make sense i.e data is logically stored.
Normalization Rule
1. First Normal Form
2. Second Normal Form
3. Third Normal Form
4. BCNF