What is the primary purpose of normalization in relational databases?
A
Increase redundancy
B
Reduce redundancy
C
Increase storage space
D
Improve graphics rendering
Correct Answer: Option B — Reduce redundancy
Explanation:
Normalization organizes data into structured tables to minimize redundancy and dependency issues. It improves data integrity, reduces update anomalies, and makes databases easier to maintain and scale in real-world applications.