Which statement about normalization is accurate?

Which statement about normalization is accurate?

• A. Normalization increases data redundancy to speed queries
• B. Normalization has no impact on data integrity
• C. Normalization reduces redundancy and update anomalies by organizing data into related tables
• D. Normalization eliminates the need for data storage

Answer: (C)

Normalization structures data to minimize redundancy by splitting information into related tables and linking them with keys. This arrangement ensures each fact is stored in one place, so updates, deletions, or insertions don’t have to touch multiple records and risk inconsistencies. By separating data into customers, orders, products, and similar tables, you preserve data integrity because a change in one place propagates correctly through the linked structure. It also means storage is used more efficiently since repeated data is eliminated. Therefore, the statement that normalization reduces redundancy and update anomalies by organizing data into related tables is the accurate description of what normalization accomplishes.

Normalization structures data to minimize redundancy by splitting information into related tables and linking them with keys. This arrangement ensures each fact is stored in one place, so updates, deletions, or insertions don’t have to touch multiple records and risk inconsistencies. By separating data into customers, orders, products, and similar tables, you preserve data integrity because a change in one place propagates correctly through the linked structure. It also means storage is used more efficiently since repeated data is eliminated. Therefore, the statement that normalization reduces redundancy and update anomalies by organizing data into related tables is the accurate description of what normalization accomplishes.