A Surrogate Key May Be Appropriate Under Which of the Following

question 42

Multiple Choice

A surrogate key may be appropriate under which of the following circumstances?

• A) The available candidate keys would produce a lot of data duplication when representing relationships.
• B) The primary key is numeric.
• C) The available candidate keys would be prone to typographical errors.
• D) The available candidate keys have little meaning to the users.
• E) Both A and C

---

Definitions:

Unemployment

A situation where individuals who are capable of working and willing to work are not able to find employment.

Temporary Assistance

A form of financial aid provided by government agencies to individuals and families in need for a limited period.

Needy Families

Refers to households with insufficient income or resources to maintain an adequate standard of living without external assistance.

Supplemental Security Income

A United States government program providing financial assistance to elderly, blind, or disabled individuals.