nerdexam
Microsoft

98-364 · Question #38

You are designing a database for a sports hostel. There are three types of buildings for which a fixed fee is charged on per room basis. No player can take two accommodations. You design the…

The correct answer is B. 1NF C. 2NF. See the full explanation below for the reasoning.

Question

You are designing a database for a sports hostel. There are three types of buildings for which a fixed fee is charged on per room basis. No player can take two accommodations. You design the following table:

Considering that the P_ID is the primary key, the table is in which normal form? Each correct answer represents a complete solution. Choose all that apply.

Exhibit

98-364 question #38 exhibit

Options

  • ABCNF
  • B1NF
  • C2NF
  • D3NF

How the community answered

(31 responses)
  • A
    10% (3)
  • B
    74% (23)
  • D
    16% (5)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice