Consider the following set of data requirements for a Hospital database which contains data about the...

 

Transcribed Image Text:

Consider the following set of data requirements for a Hospital database which contains data about the inpatient activities. a. 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. Each lab has a uniquely assigned number, a unique name, a manager, and a set of services. Each service has a certain cost. C. d. The patient records in the hospital records each patient's National ID, Name, Address, and Phone No. 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. e. Consider the following set of data requirements for a Hospital database which contains data about the inpatient activities. a. 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. Each lab has a uniquely assigned number, a unique name, a manager, and a set of services. Each service has a certain cost. C. d. The patient records in the hospital records each patient's National ID, Name, Address, and Phone No. 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. e.

Answer rating: 100% (QA)

Patients PK National Id Name Address Phone No Hospital Database Design FK Bed ... View the full answer