What is the objective of the normalisation process?

Answer 1

The objective of the normalization process is to eliminate data redundancy and ensure data consistency in a database. This is accomplished by organizing data into separate tables and defining relationships between them, thereby reducing the chance of inconsistencies, errors, and data anomalies. The normalization process helps to improve database performance, simplify data maintenance, and increase data integrity.