Identify the incorrect statement(s).

1. AA candidate key is minimal set of one or more attributes that, taken collectively, allows us to uniquely identify any entity in the entity set. Q
2. BA candidate key for which no proper subset is also a candidate key is called a super key.
3. CA super key is a set of one or more attributes that, taken collectively, allows us to uniquely identify any entity in the entity set.
4. DA super key for which no proper subset is also a super key is called a candidate key.

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: B. A candidate key for which no proper subset is also a candidate key is called a super key.

Explanation

A super key uniquely identifies tuples; a minimal super key (no proper subset is a super key) is a candidate key. Statement B reverses this, so it is incorrect.