Database Normalisation Questions Medium
The purpose of the normalization process in database design is to eliminate data redundancy and improve data integrity. By organizing data into multiple related tables and applying a set of rules called normalization forms, the process ensures that each piece of data is stored in only one place, reducing the chances of inconsistencies and anomalies. Normalization also helps in optimizing database performance, simplifying data maintenance, and facilitating future modifications and updates to the database structure.