Examveda

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.

This Question Belongs to Database >> The Relational Model And Normalization

Join The Discussion

Comments (1)

  1. AKSHAY SACHDEVA
    AKSHAY SACHDEVA:
    7 years ago

    Candidate Keys

Related Questions on The Relational Model and Normalization