Question

Make an ERD using the following description

Wards

The 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 over the use of the hospital resources (including staff, beds, and supplies) in the provision of cost-effective treatment for all patients. 

The Hospital has a Personnel Officer, who is responsible for ensuring that the appropriate number and type of staff are allocated to each ward and the outpatient1 clinic. The information stored for each member of staff includes a staff number, name (first and last), full address, telephone number, date of birth, gender, insurance number, position held, current salary, and salary scale. It also includes each member’s qualifications (which includes date of qualification, type, and name of institution), and work experience details (which includes the name of the organization, position, and start and finish dates).

The type of employment contract for each member of staff is also recorded, including the number of hours worked per week, whether the member of staff is on permanent basis or temporary contract, and the type of salary payment (weekly/ monthly).

Each ward and the outpatient clinic has a member of staff with the position of Charge Nurse. The Charge Nurse is responsible for overseeing the day-to-day operation of the ward/clinic. The Charge Nurse is allocated a budget to run the ward and must ensure that all resources (staff, beds, and supplies) are used effectively in the care of patients. The Medical Director works closely with the Charge Nurses to ensure the efficient running of the hospital.

A Charge Nurse is responsible for setting up a weekly staff rotation and must ensure that the ward/clinic has the correct number and type of staff on duty at any time during the day or night. In a given week, each member of staff is assigned to work an early, late, or night shift.

As well as the Charge Nurse, each ward is allocated senior and junior nurses, doctors and auxiliaries. Specialist staff (for example, consultants and physiotherapists) are allocated to several wards or the clinic.


Patients 

When a patient is first referred to the hospital, he or she is allocated a unique patient number. At this time, additional details of the patient are also recorded, including name (first and last), address, telephone number, date of birth, gender, marital status, date registered with the hospital, and the details of the patient’s next-of-kin.


Patient’s next-of-kin 

The details of a patient’s next-of-kin are recorded, which includes the next-of-kin’s full name, relationship to the patient, address, and telephone number.


Local doctors 

Patients are normally referred to the hospital by their local doctor. The details of local doctors are held, including their full name, clinic number, address, and telephone number. The clinic number is unique.


Patient appointments 

When a patient is referred by his or her doctor to attend the Hospital, the patient is given an appointment for an examination by a hospital consultant. 

Each appointment is given a unique appointment number. The details of each patient’s appointment are recorded and include the name and staff number of the consultant performing the examination, the date and time of the appointment, and the examination room (for example, Room E252).

As a result of the examination, the patient is either recommended to attend the outpatient clinic or is placed on a waiting list until a bed can be found in an appropriate ward.


Outpatients 

The details of outpatients are stored and include the patient number, name (first and last), address, telephone number, date of birth, gender, and the date and time of the appointment at the outpatient clinic.

0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 9 more requests to produce the answer.

1 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Make an ERD using the following description
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • 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...

  • Case 8.1 Abstracting Insurance Information

    Encounter Date: 05/04/2029Patient: Elizabeth R. SinowitczDate of Birth: 08/02/1954Address: 45 Maple Hill Road, Apt. 12-B, Rangeley, MN 55555Home Telephone: 555-123-9887Employer: Argon Electric Company, 238 Industry Way, Rangeley, MN 55554Work Telephone: 555-124-8754Betty is on Medicare. She also has insurance coverage through Argon Electric in the Horizon PPO. Her insurance card shows her member number as 65-PO; no group number is shown.Betty was referred to Dr. Hank R. Ferrara, a Horizon-participating ophthalmologist (PIN 349-00-G), for evaluation of her blurred and dimmed vision....

  • Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate

    2. Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s name and date of birth are recorded. Some patients are resident patients who spend at least one night in the hospital, and others are outpatients who are treated and released. Resident patients are assigned a room. Each room is identified by...

  • Hello I need to Convert the ER Diagram to a relational model. Analyze each table to...

    Hello I need to Convert the ER Diagram to a relational model. Analyze each table to make sure that they are in 3rd Normal Form. Write the level of normalization for each table and state in your report why it is an acceptable level of normalization. Physical Database Design: identify the data types of each columns (in each table). Gender Register Date Name Doctor ID Patient ID Room No Patient Salary qualification Consults Tel No DOB Staff Name Gender Staff...

  • We would like to design a database to maintain information about hospital staff, including doctors and...

    We would like to design a database to maintain information about hospital staff, including doctors and nurses, and patients at the hospital. Construct a crow’s feet diagram using the information provided. The information we need includes: Staff, including their names, addresses and social-security numbers. Patients, including their names, addresses, and the name of their insurance company. Patients are each assigned to a ward (room). Those staff who are nurses are assigned to zero or more wards. Each ward has at...

  • Using the descriptions of the attributes given in the following figure, convert the ERD into a...

    Using the descriptions of the attributes given in the following figure, convert the ERD into a dependency diagram that is in at least 3NF. APPOINTMENT PK App Num FK1 Doc_EmplD DOCTOR App_Date App_Time PK Doc Emplo App_PatientID -H- App_Name Doc Fname App_Phone Doc_Lname App_Street Doc_CellPhone App_City App_State App_Zip Doc_EmpID: Employee ID for the doctor. App Status Doc Fname: Doctor's first name. Doc Lname: Doctor's last name. Doc CellPhone: Doctor's cell phone number. App_Num: System-generated number. App Date: The date of...

  • Create Datasets for the ABC University Accommodation Office using the information below.This is a list of...

    Create Datasets for the ABC University Accommodation Office using the information below.This is a list of all the datasets and data attributes that the Office needs to function. For example, a STUDENT dataset containing StudentIDNumber, StudentFirstName, etc Scenario - ABC University Accommodation Office (Student Housing) The director of the ABC University Accommodation Office requires you to design a database to assist with the administration of the office and the renting of residences to students. The requirements collection and analysis phase...

  • Case Study You have been hired to manage a portfolio of several specialty clinics in a...

    Case Study You have been hired to manage a portfolio of several specialty clinics in a large multi-physician group practice in an academic medical center. The clinics reside in a multi-clinic facility that houses primary care and specialty practices, as well as satellite laboratory, radiology and pharmacy services. The practice provides the following centralized services for each of its clinics: Registration Payer Interface (e.g., authorization) Billing The CEO of the practice has asked you to initially devote your attention to...

  • E-R model creation help I need help creating a E-R model for a healthcare. In the...

    E-R model creation help I need help creating a E-R model for a healthcare. In the hospital, there are several rooms. Each room has an ID general description of equipment in rooms.Each room can be scheduled with multiple test and each IR test will be scheduled and conducted in only one room. The test, will be a key(encounter number) displays the associated date of service, provider and time of appointment which will key. It included the start time and end...

  • 2. [2 marks] [2 marks] (a) Is the following statement true or false? Justify your answer....

    2. [2 marks] [2 marks] (a) Is the following statement true or false? Justify your answer. "A use case diagram describes a sequence of use cases representing the behaviour of the system when interacting with its environment (i.e., the actors)." (b) Is the following statement true or false? Justify your answer. "Structural models display the organisation of a system in terms of what the system does." (c) Is the following statement true or false? Justify your answer. "A good design...

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