Two members of a database design team at Large U.S. University assigned different primary keys to the Student entities in their models. One member used Student ID, an internally generated unique number the university assigns to each student upon enrollment. The other chose social security number or other equivalent identifier assigned to each student by the U.S. government. This is an example of
A) Entity name conflict
B) Attribute conflict
C) Cardinality conflict
D) Relationship name conflict
E) Relationship structure conflict

Question

Quizplus · Accepted Answer

This is an example of attribute conflict because the two team members have chosen different attributes (Student ID and social security number) to serve as the primary key for the Student entity.

Two Members of a Database Design Team at Large U