Normalization primarily aims to reduce redundancy by organizing data into related entities. True or False?

• A. True
• B. False
• C. Partially True
• D. Not at all

Answer: (A)

Normalization reduces redundancy by organizing data into related entities. By breaking a large table into smaller, related tables and using keys to connect them, each fact is stored in one place, which minimizes repeated information. For example, separating data into a Student table (student_id, name, etc.), a Course table (course_id, title, etc.), and an Enrollment table that references those IDs (student_id, course_id, grade) means a student’s name or a course title isn’t repeated in every row. When you update a name, you change it in one place, keeping the data consistent and avoiding update anomalies. This is the main purpose of normalization: to reduce duplication and improve data integrity. In real designs, a bit of redundancy might be kept for performance reasons (denormalization), but the core aim remains reducing duplication. So the statement is true.