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


E

Business

You might also like to view...

Proponents of personalistic ethics argue that

A. everyone ought to decide for themselves what is right based on their conscience. B. the best way to achieve the greatest good is to closely follow a set of rules and principles. C. the worth of a particular action is judged on the basis of the consequences it produces. D. societies, organizations and cultures determine what is ethically appropriate and acceptable within that group.

Business

Which of the following is not a test of access controls?

a. biometric controls b. encryption controls c. backup controls d. inference controls

Business

A business using cash to expand by purchasing land and a building is an example of an operating activity

Indicate whether the statement is true or false

Business

Eft

A) means Efficient Funds Transfer B) can process certain cash transactions at less cost than by using the mail C) makes it easier to document purchase and sale transactions D) means Effective Funds Transfer

Business