U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - 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
Pamella
1 month ago
I think this table is in 1NF because it has a unique identifier for each student.
upvoted 0 times
...

Save Cancel