STUDENT NAME : MANISH KHATIWODA Student Id :11681209.

STUDENT NAME : MANISH
KHATIWODA Student Id :11681209

Dependency diagram for patient record
patient_id patient_name patient_address triage_cat seen_by presenting_
problem
clinician_
name
clinician_
location
departing
status
transitive dependency
partial depedency
student n ame :Manish Kh atiwo da Student Id :11681209 Subject code :I TC-556
From the dependency diagram we can note that triage_cat is dependent on the
presenting_problem but none of the two is a primary key. The triage cat is said to
be transitive dependent on the presenting_problem.
If we assume that every clinician has his/her own location that will make clinician
location to be unique and the clinician location will act as a foreign key. Clinician
name and first_seen_by field wil partially depend on clinician_location.
B). Modify the diagram to meet 3NF requirements. Rename attributes to
meet the naming convention and create new attributes and entities where
necessary.
First we will create new tables from our original table.
patient re cords
patient_id patient_name patient_address triage_cat clinician_no departing_statuspresenting_prob-
lem
clinician_no clinician_name clinician_location
clinician
clinician_role
student n ame :Manish Kh atiwo da Student Id :11681209 Subject code :I TC-556
The first step is to remove partial dependency attributes and create new table for
them. In our new table we have added a new attribute clinician_no to act as a
foreign key in the patient record table.