You are designing a database for a sports hostel. In the hostel, a player can be enrolled for multiplegames.
You are working on a relation shown in the image below:
Which of the following candidate keys would best serve as the primary key?
A.
P_ID and P_DOB
B.
Game_ID and P_ID
C.
Game_ID and P_Age
D.
P_ID and P_Age
Explanation:
According to the question, you are required to identify the keys that would best serve as the primary key for the
given relation. The primary
key must be unique for each row. The only combination of the candidate keys that makes it unique for each
row of the table is Game_ID and
P_ID.