Please explain why C is the correct answer Patient_Visit (DoctoriD, PatiendD, Da
ID: 3709485 • Letter: P
Question
Please explain why C is the correct answer Patient_Visit (DoctoriD, PatiendD, Date, Diagnosis, PatientName, Procedure, Charge, Billing_code) and the set of functional dependencies (F.D.s) F: PatientlD-PatientName.J DoctorID, PatientID, Date Diagnosis DoctoriD, PatientD, Date- Procedure Procedure Charge, Billing code We may conclude from above that DoctoriD, Paltenl D, DeteHisareamtidate key (Notes: 1) Given the meaning of his dala here is only omne cumbidate kay for the Patien, visit relation 2) Procedure is a code that stands for the action taken or treatment given by the doctor during that visit. E.g., endoscopy 3) Based on the F.D.s, there can be only one diagnosis and one procedure on a given patient's visit to a doctor on one day.)
Explanation / Answer
From the given Information .
Candidate key is {DoctorId,PatientId,Date).
For each row in the table this combination can not be same.
PatientID ->PatientName .
As per third row PatientID 11 corresponds to Brown.
So PatientName in first row will be Brown.
Option a can not be true because Date will violate the Uniqueness of Candidate Key.
Option b can not be true because Patient Id 1001 corresponds to name brown .and from fisrt FD there is unique name for each patient Id.
Option b can not be true because it will again violate Uniqueness of Candidate Key.
So C is correct option.