Information Technology Reference
In-Depth Information
HOSPITAL
1
1
Hospname
hosphone
admintor
Consists
applies
n
n
wardno
totrooms
totbeds
bedavail
Hospname
sequence#
factype
totfacil
facavail
WARD
FACILITY
1
occupied
wartype
n
PATIENT
1
1
bedident
patname
patphone
dateadmt
has
take
n
n
bedident
trdate
trtype
meditype
bedident
sympdate
diagnose
prevtrea
treadesc
SYMPTOM
TREATMNT
Fig. 6.3
Mapped EER model for the patient information system
Map each entity to a relation and each entity key to the relation key. Map the 1:n
relationship to a foreign key on the “many” side. The resulting relational schema is:
5HODWLRQ+263,7$/
+RVSQDPH
+RVSKRQH$GPLQWRU
5HODWLRQ:$5'
:DUGQR
+RVSQDPH7RWURRPV7RWEHGV:DUGW\SH
5HODWLRQ3$7,(17
%HGLGHQW
:DUGQR3DWQDPH3DWSKRQH'DWHDGPW
5HODWLRQ6<03720
%HGLGHQ
W
6\PSGDWH
'LDJQRVH3UHYWUHD
7UHGGHVF
5HODWLRQ75($7017
%HGLGHQW
7UGDWH
7UW\SH0HGLW\SH
5HODWLRQ)$&,/,7<
+RVSQDPH
6HTXHQFH
)DFW\SH7RWIDFLO
)DFDYDLO
Search WWH ::
Custom Search