TABLE 1: Criteria for Evaluating Candidates for Primary Key
Condition Best Answer
Not Null: Will the candidate value ever be null? no
Brevity: Is the candidate value more than a single column? no
Simplicity: Does the candidate value contain embedded spaces, special characters, or differential capitalization? no
Data Type: Is the candidate value something other than a number or fixed-length character data type? no
Nonidentifying Value: Does the candidate value contain any intelligence or have any meaning? no
Never Change: Is the candidate value likely to change? no