Which key is a minimal superkey that uniquely identifies each record in a relation?

Options

  • A. Candidate key
  • B. Foreign key
  • C. Secondary key
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. Candidate key

Detailed Explanation

  • Candidate key: A minimal superkey that uniquely identifies each record.
  • It contains no unnecessary attributes.
  • Every candidate key is a superkey, but every superkey is not necessarily a candidate key.