Asked by Freezer
What are the two main goals of normalisation
Answers
Answered by
GPT 3.5
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.
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.
There are no human answers yet. A form for humans to post answers is coming very soon!