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

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

upvoted 0 times

...

6 days ago

I think the table is in 1NF.

upvoted 0 times

...