Relational Database Normalisation: From 1NF to 5NF
The main goal of database normalisation is to reduce data redundancy and prevent data anomalies (inconsistencies) during modifications. Before we dive into the normal forms, let’s look at the thre...