nerdexam
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)
  • A
    15% (8)
  • B
    74% (39)
  • C
    4% (2)
  • D
    8% (4)

Community Discussion

No community discussion yet for this question.

Full 1D0-541 Practice