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
Correct Answer:

Verified
Correct Answer:
Verified
Q17: In Microsoft Access,a relationship is created by
Q23: Given the relations:<br>STUDENT (SID,StudentName,Major,AdvisorID)<br>ADVISOR (AdvisorID,AdvisorName,Office,Phone)<br>Such that each
Q26: Which of the following is not true
Q33: In the normalization process,if you find a
Q34: A rule that requires that the values
Q39: A key that contains more than one
Q46: A key must be unique.
Q48: In Microsoft Access,the relationship between two tables
Q71: In the relational model,each row of a
Q88: Which of the following is true about