Database Normalization

Three anomalies

Insertion Anomaly
Repetition of data in a table You are repeating student information and branch information in a table, and as a result you are duplicating data in the table. This can be inefficient and lead to

Deletion Anomaly
If you delete all the student info then you also delete all the branch info, so you lose it

Updation Anomaly
You need to update all the branch info at once across the table instead of just once

First Normal Form
First Normal Form is the default and should always be done

Rules

Normalization example
 * 1) Each row should be an atomic value, no other lines
 * 2) A column should contain values of the same kind
 * 3) Each column needs a unique name
 * 4) Order of data shouldn't matter
 * 5) Add a numbering system if necessary