Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

CIW 1D0-541 Exam - Topic 7 Question 126 Discussion

The exhibit shows a table called Housing Relation. This table relates a unique studentidentification number with a dormitory building and a room fee for that building. The key for theHousing Relation is Student_ID. If each building charges only one fee and a student can live inonly one building, then this table is in which normal form?
B) 1NF and 2NF
A) 1NF
C) 1NF, 2NF, and 3NF
D) 1NF, 2NF, 3NF, and BCNF

CIW 1D0-541 Exam - Topic 7 Question 126 Discussion

Actual exam question for CIW's 1D0-541 exam
Question #: 126
Topic #: 7
[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?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Oretha at May 15, 2026, 07:58 AM

Limited Time Offer

25%

Off

Get Premium 1D0-541 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Herman
15 hours ago
I agree, but it could also be in 2NF since there's no partial dependency.
upvoted 0 times
...
Reyes
6 days ago
It's definitely in 1NF since there's a unique identifier.
upvoted 0 times
...
Laurel
11 days ago
I’m surprised it’s not in BCNF too, seems like it should be!
upvoted 0 times
...
Blair
16 days ago
Totally agree, it's 1NF and 2NF for sure!
upvoted 0 times
...
Lina
21 days ago
Wait, how can it be in 3NF if there's no transitive dependency?
upvoted 0 times
...
Vernell
26 days ago
I think it's also in 2NF because there's no partial dependency.
upvoted 0 times
...
Glendora
1 month ago
It's definitely in 1NF since it has a unique identifier.
upvoted 0 times
...
Carin
1 month ago
I feel like it could be in BCNF too, but I’m not confident. I need to double-check the definitions of each normal form.
upvoted 0 times
...
Ira
1 month ago
I practiced a similar question, and I believe it was about normal forms. If there's only one fee per building, it might be in 3NF as well.
upvoted 0 times
...
Shawnta
2 months ago
I'm not entirely sure, but I remember something about 2NF requiring no partial dependencies. Since there's only one fee per building, maybe it qualifies for that too?
upvoted 0 times
...
Pamella
3 months ago
I think this table is in 1NF because it has a unique identifier for each student.
upvoted 0 times
...

Save Cancel