In the accompanying figure, the primary key for the Vist table is the ____ field.
A) PatientID
B) VisitDate
C) Reason
D) VisitID

Question

In the accompanying figure, the primary key for the Vist table is the ____ field.
A) PatientID 
B) VisitDate 
C) Reason 
D) VisitID

Quizplus · Accepted Answer

The primary key for a table is a unique identifier for each record in the table. The VisitID field is the only field that is specified as the primary key in the table name, making it the correct answer. The PatientID field could also be a candidate key, but it is not specified as the primary key in the table name. The VisitDate and Reason fields are not appropriate as primary keys because they are not unique for each record; multiple visits could have the same date or reason.

In the Accompanying Figure, the Primary Key for the Vist