Which key uses a real-world attribute, such as an email address or passport number, to identify a record?

Options

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

Correct Answer (Detailed Explanation is Below)

C. Natural key

Detailed Explanation

  • Natural key: Uses an attribute that has real-world meaning to identify a record.
  • Examples: Passport number or a unique national identification number.
  • Unlike a surrogate key, it is based on meaningful real-world data.