UGC-NET | UGC NET CS 2016 Aug – II | Question 17
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