Databases · Junior · Question 37 of 75
What is the main goal of database normalization?
- ✓Correct answer: Removing redundant data so each fact is stored once and updates don't create inconsistencies
- 2Making the database file smaller by compression
- 3Making all columns the same type
Explanation
If a customer's address is copied into every order, changing it means updating many rows, and missing one leaves the data inconsistent.