Microsoft
98-364 · Question #37
You are designing a database for a sports hostel. In the hostel, a player can be enrolled for multiple games. You are working on a relation shown in the image below: Which of the following candidate…
The correct answer is B. Game_ID and P_ID. See the full explanation below for the reasoning.
Question
You are designing a database for a sports hostel. In the hostel, a player can be enrolled for multiple games. You are working on a relation shown in the image below:
Which of the following candidate keys would best serve as the primary key?
Exhibit
Options
- AP_ID and P_DOB
- BGame_ID and P_ID
- CGame_ID and P_Age
- DP_ID and P_Age
How the community answered
(30 responses)- A7% (2)
- B80% (24)
- C3% (1)
- D10% (3)
Community Discussion
No community discussion yet for this question.