When Selecting an Identifier, One Should

question 52

Multiple Choice

When selecting an identifier, one should:

• A) use intelligent keys.
• B) use large composite keys instead of single-attribute surrogate keys.
• C) choose a candidate key that will not change its value over the life of each instance of the entity type.
• D) choose a candidate key such that for each instance of the entity, the attribute is guaranteed to have valid values or is null.
• E) choose a candidate key that allows for duplicate values.

---

Definitions:

Major Life Events

Significant occurrences that have a large impact on one’s life, requiring substantial adjustments in behavior or attitude.

Social Readjustment Rating Scale

A scale designed to measure the amount of stress in a person's life resulting from major life changes, as part of the stress and coping research.

Optimists

People who tend to maintain a positive outlook and approach life's challenges with confidence and hope.

Pessimists

Individuals who tend to see the worst aspect of things or believe that the worst will happen; a tendency to expect negative outcomes.