Database Design Multiple Choice According to class material, when we need to cho

Question

Database Design Multiple Choice

According to class material, when we need to choose one primary key out of all the candidate keys in an entity, we should choose the one that ____ to be the primary key. (a) is complex, with more than one key attribute combined, over one is composed of just one key attribute (b) is with values that can change over time (c) has embedded meaning over those that do not have embedded meanings (d) should not pose a security risk or violation (e) None of (a) through (d) is the correct answer.

Explanation / Answer

a.no generally these are avoided , a is not correct

b.primary key values must not change so b is not correct

c.No embedded meaning is not required, like email id cannot be selected as primary key eventhough they are unique they tend to change so c is not correct

d. d is correct, primary key should not be like social security number,email id as they can be a security risk so d is correct ans

D is correct

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.