DB Normalisation

DB Normalisation

1. Update Anomaly

   • Redundant data may suffer from update anomalies

2. Deletion Anomaly

   • If data deleted from a row, data is lost.

3. 1NF

   • Remove multi-valued rows by adding repeated groups

4. 2NF

   • Removing partial dependency

5. 3NF

   • Remove transitive relations

6. Insert Anomaly

   • Attributes cannot be inserted without presence of other attributes