Question

The disadvantages of normalization include ________.

A) the elimination of modification anomalies
B) the elimination of duplicated data
C) more complex SQL for multicable subqueries and joins
D) A and B

Answer 1

Normalization can lead to more complex SQL queries, particularly with subqueries and joins, which may affect performance and maintainability of the database.

Step-by-step explanation:

The disadvantages of normalization in database design primarily relate to performance concerns and system complexity. Among the options provided, the correct answer is C) more complex SQL for multicolumn subqueries and joins. While normalization aims to reduce data redundancy and improve data integrity, the process can lead to a database schema with multiple tables that require complex SQL queries, including numerous subqueries and joins to retrieve related data. This complexity can affect the system's performance and the developer's ability to maintain the system efficiently.