In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?
A) FirstName
B) PatientID
C) VisitID
D) VisitDate

Question

In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?
A) FirstName 
B) PatientID 
C) VisitID 
D) VisitDate

Quizplus · Accepted Answer

The most appropriate field for creating a relationship between the Patient table and the Visit table would be the PatientID field. This is because it is unique to each patient and is used as the primary key in the Patient table. In contrast, VisitID and VisitDate are unique to each visit, but may not necessarily be unique to each patient. Similarly, FirstName is not a good choice for creating a relationship between the tables as it is not unique to each patient and may not be consistent between visits.

In the Accompanying Figure, Which Field Must Be Used to Create