Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Consider the following set of data requirements for a Hospital database which contains data about the inpatient activities. The inpatient section consists of several

image text in transcribed

a. Consider the following set of data requirements for a Hospital database which contains data about the inpatient activities. The inpatient section consists of several departments and a set of labs. Each department has a unique number, unique name, a set of doctors, and a set of beds. Each department has a chairman. b. A doctor is described by his/her syndicate ID (unique), Name, Status (internal or external), and Specialization. Each doctor is allowed to work in only one department. Each bed in the hospital has an assigned number, and it has a certain category (first class, second class, ...,etc). The bed number is unique for beds of the same department. Each bed category has a certain cost. It is required to keep track of the number of beds in each department. d. Each lab has a uniquely assigned number, a unique name, a manager, and a set of services. Each service has a certain cost. C. e. The patient records in the hospital records each patient's National ID, Name, Address, and PhoneNo. A patient is assigned a bed in a department and supervised by one or more doctors (not necessary of the same department). It is required to keep track of the current admissions in each department. The check-in date and the check-out date of each patient have to be recorded. It is also required to keep track of any lab services that may be done to the patient during his/her stay Design a database for the hospital described above, illustrating your design through an ERD

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

Genomes And Databases On The Internet A Practical Guide To Functions And Applications

Authors: Paul Rangel

1st Edition

189848631X, 978-1898486312

More Books

Students also viewed these Databases questions