ZuoTi.Pro
Question

Given the following requirements: we need to construct a database that manages the hospital data. The...

Given the following requirements: we need to construct a database that manages the hospital data. The hospital contains four departments (Department of Internal Medicine, Orthopedic department, pediatric department, surgery department), each department has several doctors; each department receives and treats several patients. Each doctor has an ID number (unique); Full Name; Gender; Department ID number, each patient has an ID number (unique); Full Name; Gender; Department ID number; Condition (admitted or not), The doctor in charge; the described medications (serial number of the medicine ) where the patients can take more than one medicine. Each patient is treated by one doctor. The hospital medicine storages have several medicines where each has a serial number, type, and name.

1.Produce the ER diagram the represents these requirements.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
Given the following requirements: we need to construct a database that manages the hospital data. The...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Consider the following information about a patient database: A patient is identified by patient id, and...

    Consider the following information about a patient database: A patient is identified by patient id, and admission date. A patient must be either an Emergency patient or a resident patient. We must record the checkback date for Emergency patient. Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need...

  • Question 3 refers to the relational database with a schema described below: The hospital database contains...

    Question 3 refers to the relational database with a schema described below: The hospital database contains information about the treatments of patients performed by the doctors. The database also contains information on the prescriptions ordered by the doctors. The schemas of relational tables, the meanings of attributes and specifications of primary, candidate, and foreign keys are given below. HOSPITAL HospitalCd Name Address Estate PostalCode EstablishedDate Hospital Code Name of the hospital Address of the hospital The estate where the hospital...

  • Make an ERD using the following description

    WardsThe Hope Hospital has 17 wards with a total of 240 beds available for short- and long-term patients, and an outpatient clinic. Each ward is uniquely identified by a number (for example, ward 11) and also a ward name (for example, Orthopedic), location (for example, E Block), total number of beds, and telephone extension number (for example, Extn. 7711).Staff The Hospital has a Medical Director, who has overall responsibility for the management of the hospital. The Medical Director maintains control...

  • Question 1. Prepare an Entity-Relationship diagram for the following requirements of a medical clinic The clinic...

    Question 1. Prepare an Entity-Relationship diagram for the following requirements of a medical clinic The clinic has a set of patients and a set of specialist medical doctors. A doctor sees many patients and a patient may have many doctors Patients take various tests. Many specialist doctors may consult on a test and recommend it. A doctor can recommend many tests However, a test is only for one patient. So I get blood pressure tested but it cannot be for...

  • Diagram the below business rules into a complete EERD. A doctor’s office keeps information on the...

    Diagram the below business rules into a complete EERD. A doctor’s office keeps information on the doctors, the patients, and the medicines a. An id number and name are associated to each doctor, to each patient, and to each medicine. The ids identify each specific person or item. The doctor’s address, phone, and specialty are stored in the system. The patient’s phone number, address, and insurance carrier are stored in the system. Each medicine’s supplier and cost are stored in...

  • DRAW AN ER DIAGRAM TO MAP IT OUT: The Problem: The database you design should be...

    DRAW AN ER DIAGRAM TO MAP IT OUT: The Problem: The database you design should be for the following scenario: OHIP wants to keep track of it's doctors and patients and hospitals. For the doctors, you must keep track of the doctor's license number. The license number is 4 character alphanumeric, for example 4RG2. Also, you must keep track of the doctor's first name (up to 20 letters), last name(up to 20 letters), specialty (up to 30 letters) and the...

  • Assume that you are working with a hospital and this hospital needs a software system to...

    Assume that you are working with a hospital and this hospital needs a software system to track its patients’ information. Your role in this software development is to design the database. There are many aspects of such a hospital software system to develop. However, in this assignment, you will only address interactions between doctors and patients. Your first step will be to create the relations necessary for this system and identify and describe the constraints that would be appropriate for...

  • Design the entity relationship conceptual schema. Depict the ER diagram you have designed, outlining the entity...

    Design the entity relationship conceptual schema. Depict the ER diagram you have designed, outlining the entity types, relationship types, their respectives attributes, keys, structual constraints, and role names. In designing the entity relationship schema, make the initial conceptual design and the neccessary refinements after that. This will be a hospital database hospital, include patients, each patient will be either inpatient or outpatient and have a unique ID, first name, last name, address, city, zip code, phone number, and room number....

  • paython code :- UML A hospital is a very busy place with a lot of patients...

    paython code :- UML A hospital is a very busy place with a lot of patients and also a lot of employees to keep the system running perfectly. All people in the hospital have basic information like title, name, gender, address, and phone number. Employees of the hospital have extra information like employee-id and salary. For every 25 employees, there is a manager who is also an employee, but gets an allowance of 7% more than the salary. There are...

  • Draw ER Diagrams for the following narratives. Draw ER Diagrams for the following narratives. The Human League Surgery...

    Draw ER Diagrams for the following narratives. Draw ER Diagrams for the following narratives. The Human League Surgery has doctors, nurses, midwives and patients. The patient has to telephone for appointments with the doctors or nurses and these appointments are allocated by the receptionist. An appointment can only be made with one doctor, midwife or nurse at a time. A patient may also only be registered with one doctor. 1. "Authors are responsible for writing plays that are performed in...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT