(For this assignment, you need submit a gif picture containing your E-R diagram. The size of the picture should be less

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

(For this assignment, you need submit a gif picture containing your E-R diagram. The size of the picture should be less

Post by answerhappygod »

(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, ...
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply