Databases Reference
In-Depth Information
Table 7: Determination of conceptual model fi tness
Models DFD ER CD DTE STC UC
Entity[repl]: Rooms X X X X
Entity[repl]: Wards X X X X
Entity[repl]: Complaints
X
X
X
X
Entity[repl]: Patients
X
X
X
X
Entity[repl]: Doctors_1
X
X
X
X
Entity[repl]: Doctors_2
X
X
X
X
Entity[repl]: Doctors
X
X
X
X
Entity[repl]: Waiting list
Subs:
subs
Entity[repl]:
Patient
X
Entity[repl]: Emergency dept.
Subs:
subs
Entity[repl]:
Patients
X
Entity[repl]: Doctors_2
Subs:
subs
Entity[repl]:
Doctors_1
X
Entity[repl]: Emergency doc-
tors
Subs:
subs
Entity[repl]:
Doctors_1
X
Entity[notrepl]: Complaint
Bel: bel Entity[repl]:
Complaints
Entity[notrepl]: Room
Bel: bel Entity[repl]:
Rooms
Entity[notrepl]: Patient_1
Bel: bel Entity[repl]:
Waiting list
Entity[notrepl]: Patient_2
Bel: bel Entity[repl]:
Emergency dept.
Entity[notrepl]: Ward
Bel: bel Entity[repl]:
Wards
Entity[notrepl]: Doctor_1
Bel: bel Entity[repl]:
Doctors
Entity[notrepl]: Doctor_2
Bel: bel Entity[repl]:
Emergency
doctors
p1
Entity[notrepl]: Hospital 123
Rel:
admits
Entity[repl]:
Patients
X
X
p2
Entity[repl]: Doctors_2
Rel: are
special-
ized in
Entity[notrepl]:
Complaint
X
X
p3
Entity[notrepl]: Patient_1
Rel:
suffers
Entity[notrepl]:
Complaint
X
X
p4
Entity[notrepl]: Patient_1
Rel: is
as-
signed
Entity[notrepl]:
Room
X
X
Entity[notrepl]: Ward
-Pof:
has
Entity[repl]:
Rooms
p5
X
p6
Entity[notrepl]: Ward
Rel: is
as-
signed
to
Entity[notrepl]:
Complaint
X
X
