(For this assignment, you need submit a gif picture containing your E-R diagram. The size of the picture should be less
Posted: Fri May 20, 2022 6:32 pm
(For this assignment, you need submit a gif picture containing
your E-R diagram. The size of the picture should be less than
100k.)
Construct an E-R diagram for a hospital with a set of patients,
a set of wards, a set of doctors and a set examinations on
patients. Associate patients with doctors (start_date, end_date)
and wards(start_date, end_date, bed_num) , and associate each
examination with a doctor and a patient.
Hint: There are following main attributes in the E-R
diagram.
patient: ID, name, address (consists of
state, city, street), ...
doctor: ID, name, specialization, phones,
...
ward: building, room_num, capacity,
...
examination: ID, type, date_time (consists
of date, start_time, end_time), result, ...
your E-R diagram. The size of the picture should be less than
100k.)
Construct an E-R diagram for a hospital with a set of patients,
a set of wards, a set of doctors and a set examinations on
patients. Associate patients with doctors (start_date, end_date)
and wards(start_date, end_date, bed_num) , and associate each
examination with a doctor and a patient.
Hint: There are following main attributes in the E-R
diagram.
patient: ID, name, address (consists of
state, city, street), ...
doctor: ID, name, specialization, phones,
...
ward: building, room_num, capacity,
...
examination: ID, type, date_time (consists
of date, start_time, end_time), result, ...