In a relational database, what is the role of PATIENT_MRN in the PATIENT and VISIT tables?
A)Foreign key in PATIENT, primary key in VISIT
B) Primary key in both PATIENT and VISIT
C) Primary key in PATIENT, foreign key in VISIT
D) Foreign key in both PATIENT and VISIT
C) Primary key in PATIENT, foreign key in VISIT