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.
Join The Discussion
Comments (1)
Related Questions on The Relational Model and Normalization
A. A → B.
B. A → C.
C. A → (B,C).
D. (B,C) → A.
A. normal forms.
B. referential integrity constraints.
C. functional dependencies.
D. None of the above is correct.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
A. second normal form.
B. third normal form.
C. fourth normal form.
D. domain/key normal form.

Candidate Keys