Normalization & Schema Design · SQL SQL
What is the primary objective of normalizing a database to the Third Normal Form (3NF)?
Practice question from Normalization & Schema Design (SQL SQL), with the correct answer and a step-by-step solution.
easy · MCQ · Q-734808
What is the primary objective of normalizing a database to the Third Normal Form (3NF)?
- A.To eliminate all foreign keys and enforce a flat file structure.
- B.To remove partial and transitive functional dependencies, reducing data redundancy.Correct answer
- C.To ensure that every table has at least ten columns.
- D.To maximize query execution speed by creating non-clustered indexes on all columns.
Solution
3NF requires that a relation is in 2NF (no partial dependencies) and has no transitive dependencies (non-prime attributes depending on other non-prime attributes), which primarily reduces data redundancy and anomalies.
More from Normalization & Schema Design
- A relation R(A, B, C, D) has the functional dependencies F = {AB -> C, C -> D, D -> A}. What is the highest normal form satisfied by R?
- Which of the following describes a Boyce-Codd Normal Form (BCNF) violation?
- When is intentional denormalization typically justified in a production relational database?
- What type of data anomaly occurs when deleting a record inadvertently causes other unrelated domain information to be lost from the databas…
Practise more SQL
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed