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?

Suggested Answer: B
Get Premium 1D0-541 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
28 comments · newest first
LA
Lashaunda
4 days ago
Agree, just unique IDs and fees.
DE
Deandrea
9 days ago
I think it's in 1NF. Simple structure.
FL
Fletcher
14 days ago
I feel it's just 1NF. Nothing more complex here.
ME
Meaghan
19 days ago
I lean towards 1NF, 2NF, and 3NF. No transitive dependencies.
HI
Hillary
25 days ago
Definitely 1NF and 2NF. Unique student IDs help.
MI
Mirta
30 days ago
But it could also be in 2NF. No partial dependencies.
DE
Demetra
1 month ago
Agreed, only one fee per building.
WI
Wilda
1 month ago
I think it's in 1NF. Simple structure.
RA
Raymon
2 months ago
I feel like it's just 1NF too. Simple structure!
CA
Carlee
2 months ago
No, it's definitely not 3NF.
LO
Lonny
2 months ago
I agree, but it could also be 2NF.
RO
Rosendo
2 months ago
Because each student has a unique ID.
RA
Raymon
2 months ago
Why just 1NF?
RO
Rosendo
2 months ago
I think it's in 1NF.
SH
Shaquana
3 months ago
Surprised it's not in BCNF too, seems like it should be!
ER
Ernest
3 months ago
I think it's just 1NF and 2NF, not all the way to 3NF.
LA
Lawrence
3 months ago
Wait, how can it be in 3NF if there's no transitive dependency?
HE
Herman
3 months ago
I agree, but it could also be in 2NF since there's no partial dependency.
RE
Reyes
3 months ago
It's definitely in 1NF since there's a unique identifier.
LA
Laurel
3 months ago
I’m surprised it’s not in BCNF too, seems like it should be!
BL
Blair
4 months ago
Totally agree, it's 1NF and 2NF for sure!
LI
Lina
4 months ago
Wait, how can it be in 3NF if there's no transitive dependency?
VE
Vernell
4 months ago
I think it's also in 2NF because there's no partial dependency.
GL
Glendora
4 months ago
It's definitely in 1NF since it has a unique identifier.
CA
Carin
4 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.
IR
Ira
4 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.
SH
Shawnta
5 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?
PA
Pamella
6 months ago
I think this table is in 1NF because it has a unique identifier for each student.