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
Carlee
5 days ago
No, it's definitely not 3NF.
upvoted 0 times
...
Lonny
10 days ago
I agree, but it could also be 2NF.
upvoted 0 times
...
Rosendo
15 days ago
Because each student has a unique ID.
upvoted 0 times
...
Raymon
20 days ago
Why just 1NF?
upvoted 0 times
...
Rosendo
25 days ago
I think it's in 1NF.
upvoted 0 times
...
Shaquana
1 month ago
Surprised it's not in BCNF too, seems like it should be!
upvoted 0 times
...
Ernest
1 month ago
I think it's just 1NF and 2NF, not all the way to 3NF.
upvoted 0 times
...
Lawrence
1 month ago
Wait, how can it be in 3NF if there's no transitive dependency?
upvoted 0 times
...
Herman
2 months ago
I agree, but it could also be in 2NF since there's no partial dependency.
upvoted 0 times
...
Reyes
2 months ago
It's definitely in 1NF since there's a unique identifier.
upvoted 0 times
...
Laurel
2 months ago
I’m surprised it’s not in BCNF too, seems like it should be!
upvoted 0 times
...
Blair
2 months ago
Totally agree, it's 1NF and 2NF for sure!
upvoted 0 times
...
Lina
2 months ago
Wait, how can it be in 3NF if there's no transitive dependency?
upvoted 0 times
...
Vernell
2 months ago
I think it's also in 2NF because there's no partial dependency.
upvoted 0 times
...
Glendora
3 months ago
It's definitely in 1NF since it has a unique identifier.
upvoted 0 times
...
Carin
3 months 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
3 months 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
3 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
5 months ago
I think this table is in 1NF because it has a unique identifier for each student.
upvoted 0 times
...

Save Cancel