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.
OOps! You are currently offline.