1Z0-060 · Question #151
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
The correct answer is B. Second normal form. A table is in Second Normal Form (2NF) when it satisfies First Normal Form (no multi-valued attributes) and has no partial dependencies - meaning every non-key attribute depends on the whole primary key.
Question
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
Options
- AFirst normal form
- BSecond normal form
- CThird normal form
- DFourth normal form
How the community answered
(61 responses)- A2% (1)
- B93% (57)
- C3% (2)
- D2% (1)
Why each option
A table is in Second Normal Form (2NF) when it satisfies First Normal Form (no multi-valued attributes) and has no partial dependencies - meaning every non-key attribute depends on the whole primary key.
First Normal Form only requires that all column values are atomic and eliminates repeating groups or multi-valued attributes, but it does not address partial dependencies on a composite key.
Second Normal Form builds directly on First Normal Form by requiring that all attributes are atomic (eliminating multi-valued attributes) and that every non-key attribute is fully functionally dependent on the entire primary key, not just part of it. A partial dependency occurs when a non-key attribute depends on only a subset of a composite primary key, and 2NF specifically eliminates this condition. Together these two requirements precisely match what is described in the question.
Third Normal Form requires 2NF compliance plus the elimination of transitive dependencies (non-key attributes depending on other non-key attributes), which is a stricter condition not mentioned in the question.
Fourth Normal Form addresses multi-valued dependencies between independent multi-valued facts about an entity, which is a more advanced concern beyond partial dependencies.
Concept tested: Database normalization - Second Normal Form (2NF) definition
Source: https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
Topics
Community Discussion
No community discussion yet for this question.