Question

Identify the correct statement(s).

oA Candidate Key is a set of one or more attributes that, taken collectively, allows us to uniquely identify any entity in the entity set
o A Candidate Key for which no proper subset is also a Candidate Key is called a Super Key
o 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
o A Super Key for which no proper subset is also a Super Key is called a Candidate Key

Answer 1

Option a is answer. In the context of database relations, a Candidate Key is a minimal set of attributes uniquely identifying each tuple in a relation, but not all Super Keys are Candidate Keys.

Step-by-step explanation:

The statements provided are related to the concepts of Candidate Key and Super Key in the context of databases. A Candidate Key is a set of one or more attributes that can uniquely identify every tuple (or entity) in a relation (or entity set). This means that for every distinct tuple, there is a distinct candidate key value. Importantly, no subset of a candidate key can provide this unique identification property.

On the other hand, a Super Key is also a set of one or more attributes that can uniquely identify tuples in a relation, but its definition is more inclusive. A super key may consist of extra attributes that are not necessary for unique identification. Therefore, a Candidate Key is a minimal super key such that its removal of any attribute from it results in a loss of the unique identification feature.