Question

Patient Report nameClini 160 104 310 A210 19 atient nan addressTriage cian locationDeparting rst seen stahs W237651 Wilbins Albary W237631Wiliams Albary B849821 Baker S154987 alls ba ieadache Aditted parted paeted odd vid thurst raage 234159 acobs itted Zea

To keep track of patients and clinician, etc., a private hospital uses the table structure shown in Table 1 Patient Report

a. Given that information, draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. (5 Marks)

Answer 1

Dependency diagram partial dependency Patient id Patient name Patient address Triage category First seen by Presenting problem clinician name clinician locat on Daparting status transitive dependency full dependency

Do ask if any doubt. Please upvote.