The primary key is selected from the:
A. composite keys.
B. determinants.
C. candidate keys.
D. foreign keys.
Answer: Option C
Solution (By Examveda Team)
Option1: Composite keys are keys that consist of multiple attributes to uniquely identify a record in a table. The primary key is not selected from composite keys because it is a single attribute or a combination of attributes that uniquely identifies each record in a table.Option2: Determinants are attributes that determine other attributes in a table. The primary key is not selected from determinants because it is the key that uniquely identifies each record in a table, not an attribute that determines other attributes.
Option3: Candidate keys are keys that could potentially be selected as the primary key for a table. The primary key is selected from candidate keys because it is the key that is chosen to uniquely identify each record in a table.
Option4: Foreign keys are keys that establish a relationship between two tables. The primary key is not selected from foreign keys because it is a key that uniquely identifies records within a single table, not a key used to establish relationships between tables.
Conclusion: The primary key is selected from the candidate keys. Candidate keys are keys that could potentially be chosen as the primary key for a table, and the primary key is the key that is ultimately selected to uniquely identify each record in a table.
Candidate Keys