Microsoft
98-364 · Question #118
John works as a Database Administrator for Bluewell Inc. The company has a SQL Server database. A table in the database has a candidate key and an attribute that is not a constituent of the…
The correct answer is B. 2 NF. See the full explanation below for the reasoning.
Question
John works as a Database Administrator for Bluewell Inc. The company has a SQL Server database. A table in the database has a candidate key and an attribute that is not a constituent of the candidate key. The non-key attribute depends upon the whole of the candidate key rather than just a part of it. Which of the following normal forms is represented in the scenario?
Options
- A4 NF
- B2 NF
- C1 NF
- D3 NF
How the community answered
(29 responses)- A10% (3)
- B69% (20)
- C3% (1)
- D17% (5)
Community Discussion
No community discussion yet for this question.