A ______ of a relation is a set of one or more attributes whose values are…
2020
A ______ of a relation is a set of one or more attributes whose values are guaranteed to identify tuples in the relation uniquely.
- A.
foreign key
- B.
super key
- C.
key
- D.
scheme
Attempted by 431 students.
Show answer & explanation
Correct answer: B
A super key is any set of one or more attributes whose values uniquely identify each tuple in a relation. A candidate key is only a minimal super key, and a primary key is a chosen candidate key. Since the question does not require minimality, the correct term is super key. Therefore, Option B is correct.