CIW
1D0-541 · Question #28
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…
The correct answer is B. 1NF and 2NF. See the full explanation below for the reasoning.
Question
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?
Options
- A1NF
- B1NF and 2NF
- C1NF, 2NF, and 3NF
- D1NF, 2NF, 3NF, and BCNF
How the community answered
(53 responses)- A15% (8)
- B74% (39)
- C4% (2)
- D8% (4)
Community Discussion
No community discussion yet for this question.