Vidyalelo
Database · Q5

The Relational Model and Normalization

Programming · Database · question 5

Q5

The primary key is selected from the:

A.
composite keys.
B.
determinants.
C.
candidate keys.
Answer
D.
foreign keys.

Answer: Option C

Solution

Answer: Option C
Solution:
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.