Relational database schema normalization is NOT for:
(A) reducing the number of joins required to satisfy a query.
(B) eliminating uncontrolled redundancy of data stored in the database.
(C) eliminating number of anomalies that could otherwise occur with inserts and deletes.
(D) ensuring that functional dependencies are enforced.


Answer: (A)

Explanation:

• Relational database schema normalization is NOT for reducing the number of joins required to satisfy a query.
• Relational database schema normalization is for eliminating uncontrolled redundancy of data stored in the database.
• Relational database schema normalization is for eliminating number of anomalies that could otherwise occur with inserts and deletes.
• Relational database schema normalization is for ensuring that functional dependencies are enforced.

So, option (A) is correct.


Quiz of this Question