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
Options
- ABCNF
- B1NF
- C2NF
- D3NF
How the community answered
(31 responses)- A10% (3)
- B74% (23)
- D16% (5)
Community Discussion
No community discussion yet for this question.
