What are the two main goals of normalisation

Answer 1

The two main goals of normalization are:

1. To eliminate data redundancy: Normalization aims to eliminate repetitive and duplicate data from the database. It ensures that each piece of data is stored only once, which reduces data redundancy and improves data consistency.

2. To achieve data consistency: Normalization helps to organize and structure data in a way that ensures data integrity and consistency throughout the database. This is achieved by defining relationships between tables and enforcing rules to maintain the accuracy and validity of data.