Question

dentify the correct statement(s).

A Candidate Key is a set of one or more attributes that, taken collectively, allows us to
uniquely identify any entity in the entity set
A Candidate Key for which no proper subset is also a Candidate Key is called a Super Key

A Super Key is a set of one or more attributes that, taken collectively, allows us to uniquely
identify any entity in the entity set
A Super Key for which no proper subset is also a Super Key is called a Candidate Key

Answer 1

The last two sentences in the given options are the correct statements.

A Superkey is a set of 1 or more attributes which when taken collectively, allows to uniquely identify any entity from the entire entity set. A superkey may have many extraneous attributes. It is an attribute or a set of attributes that help in identifying a record.

A superkey which does not have proper subset is also a kind of superkey which is called as the Candidate key. Many distinct sets of attributes can serve as the candidate keys. A candidate key is a superkey within a relation. It is the minimum superkey.