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:

Inventory

Items owned by a company consisting of raw materials, work-in-process, and finished goods that are considered to be part of the business's assets that are ready or will be ready for sale.

Intra-entity Transfers

Transactions involving assets, services, or funds between divisions or departments within the same entity.

Voting Stock

Shares that grant the shareholder the right to vote on corporate matters, such as the election of the board of directors.

Foreign Corporation

A company that is incorporated in a country outside of where it operates or conducts its business.