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

Question

Quizplus · Accepted Answer

A surrogate key would be appropriate when the available candidate keys would produce a lot of data duplication or would be prone to typographical errors. In both these scenarios, using a surrogate key, typically a numeric identifier that has no meaning to users, can help reduce data duplication and errors. Therefore, both options A and C are valid reasons to consider using a surrogate key.

A Surrogate Key May Be Appropriate Under Which of the Following