Machine-translated by Google. Questions are authored in English.
Top

Discussion

A set of one or more attributes which, taken collectively, allow us to uniquely identify an entity in the entity set is called ................. .

  • A.Primary key
  • B.Foreign key
  • C.Super key
  • D.Candidate key

Answer: C

Such a set of attributes is a super key.

A super key is any set of one or more attributes that, taken together, uniquely identify an entity in the entity set. It may contain extra attributes that are not needed for uniqueness.

A candidate key is a minimal super key, with no unnecessary attributes. A primary key is the candidate key chosen by the designer. A foreign key refers to the key of another relation and need not be unique at all. The definition in the question, without any minimality condition, is that of a super key.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.