What is the primary advantage of using Normalization in

Solution

Normalization is the process of organizing a relational database in such a way that it reduces redundancy and eliminates undesirable characteristics like insertion, update, and deletion anomalies. The goal of normalization is to ensure that:

• Data redundancy is minimized, which reduces storage costs and prevents inconsistent data.
• Data dependency is minimized by breaking down large tables into smaller, manageable ones and linking them via foreign keys.

• A is incorrect because normalization does not necessarily reduce the number of tables but instead organizes data across multiple tables more effectively.
• B is incorrect because normalization is aimed at reducing redundancy and improving data integrity, not increasing redundancy. It might slightly decrease query performance due to the increase in joins between tables.
• D is incorrect because normalization might not directly improve query performance; it can actually slow it down due to the increased number of joins.
• E is incorrect because, while normalization introduces some complexity in the schema (due to the use of foreign keys), its primary goal is not to increase complexity but to organize data in a way that reduces redundancy and dependency.