What are the two main goals of normalisation
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.
The two main goals of normalization are to reduce redundancy and to ensure data integrity in a database.
1. Reducing redundancy: Redundancy refers to the duplication of data in a database. By normalizing a database, redundant data is eliminated or minimized. This helps to optimize storage space and improve data consistency since updates or changes only need to be made in one place.
2. Ensuring data integrity: Data integrity means that the data in a database is accurate, consistent, and reliable. Normalization helps to achieve data integrity by breaking down data into smaller, more manageable tables and establishing relationships between them. This ensures that each piece of data is stored in the most appropriate and logical place, making it easier to maintain data consistency and preventing data inconsistencies or anomalies.