How Many Candidate Key Is Possible in Given Relation

Candidate Key: The minimal set of attributes that can uniquely identify a tuple is known as a candidate key. For Example, STUD_NO in STUDENT relation. The value of the Candidate Key is unique and non-null for every tuple. There can be more than one candidate key in a relation.

How many candidate keys are possible in a table?

It is because, in a table, we can have one or more than one candidate key, but we can create only one primary key for a table.

Can there be more than one candidate key?

A table can have only one primary key. Candidate key is also a unique key to identify a record uniquely in a table but a table can have multiple candidate keys.