CIW Exam 1D0-541 Topic 2 Question 90 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 90
Topic #: 2

[All 1D0-541 Questions]

The exhibit shows a table called Housing Relation. This table relates a unique student

identification number with a dormitory building and a room fee for that building. The key for the

Housing Relation is Student_ID. If each building charges only one fee and a student can live in

only one building, then this table is in which normal form?

A1NF

B1NF and 2NF

C1NF, 2NF, and 3NF

D1NF, 2NF, 3NF, and BCNF

Show Suggested Answer

Suggested Answer: B

by Rhea at Jun 20, 2024, 11:29 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 days ago

But shouldn't it be in 2NF as well, since there are no partial dependencies?

upvoted 0 times

...

9 days ago

The question is straightforward, and the information provided seems clear. I think the answer is C) 1NF, 2NF, and 3NF.

upvoted 0 times

...

13 days ago

I agree with Carey, because each student has a unique ID.

upvoted 0 times

...

15 days ago

I think the table is in 1NF.

upvoted 0 times

...