Difficulty: Easy
Correct Answer: identifies a row.
Explanation:
Introduction / Context:
A key is central to ensuring entity integrity in a relational table. Understanding what a key actually does—beyond its physical representation—helps avoid design mistakes.
Given Data / Assumptions:
Concept / Approach:
The purpose of a key is to uniquely identify each row (tuple). Whether this key is one column or multiple columns is incidental; the defining property is uniqueness and minimality (for candidate keys).
Step-by-Step Solution:
Verification / Alternative check:
Relational design guidelines define a key as a unique identifier for tuples.
Why Other Options Are Wrong:
Must be two or more columns / can only be one column: Both are false—keys can be either.
Identifies a column: Keys are constraints over columns; they don’t identify columns.
Used only for sorting: Sorting is unrelated; keys provide uniqueness and referential anchors.
Common Pitfalls:
Believing all keys must be composite or single—design drives the choice.
Final Answer:
identifies a row.
Discussion & Comments