ITPEC IP April 2018 Question 27

Normalization reduces duplicated data and thereby prevents update anomalies and inconsistencies. Storing each fact in an appropriate table means a change usually needs to be made in one place instead of in several repeated rows that could become contradictory.

Answer (b)

Why not others:
- normalization separates data by dependency rather than compiling frequently used data into one table
- its goal is logical integrity, not making table sizes uniform for memory efficiency
- it often increases the number of tables and joins, so shorter query response is not guaranteed

Key rule: Normalization organizes attributes according to dependencies to reduce redundancy and insertion, update, and deletion anomalies.

AI-generated — may contain errors