Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw the E/R diagram for the following database description You must use inheritance and include he details, such as keys, weak entities (if any), ete.

image text in transcribed

Draw the E/R diagram for the following database description You must use inheritance and include he details, such as keys, weak entities (if any), ete. There are two types of patients admitted to a hospital. Out-patients and Resident-patients. Both have a responsible Physician assigned and have an Admit-date. Only Resident-patients are assigned a bed (which may be currently epty). Both types of patients are identified by a patient ID. Out-Patients have a Check-Back-Date when they are to return for further testing. and a Resident-patient has a Discharge-Date. Beds are assigned to hospital rooms, there are at most 2 beds in each room. There are two types of beds, ICU beds and regular beds. Beds do not have a serial number or an ID. Physicians have also SSN, name, address and phone number

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Temporal Databases Research And Practice Lncs 1399

Authors: Opher Etzion ,Sushil Jajodia ,Suryanarayana Sripada

1st Edition

3540645195, 978-3540645191

Students also viewed these Databases questions