You are developing an entity relationship diagram. In the entity of patient shown here, which of the attributes in the primary key?

Question

Quizplus · Accepted Answer

The medical record number is typically a unique identifier assigned to each patient, making it the best choice for the primary key attribute in the patient entity. Last name, first name, and street address are not necessarily unique to each patient and therefore not suitable as primary key attributes.

You Are Developing an Entity Relationship Diagram