Appendix B.3 - Well Meadows Hospital Case Study | Hospital | Patient

 

wellmeadows hospital case study

Resource: Appendix B.3, "The Wellmeadows Hospital Case Study" of Database Systems: A Practical Approach to Design, Implementation and Management (6 th edition). Review the case study The Wellmeadows Hospital Case Study" in Appendix B.3 of Systems: A Practical Approach to Design, Implementation and Management.. Develop a Database Security and Optimization Plan for Wellmeadows Hospital . DATABASE DESIGN: NORMALIZATION Q & A Examine the Patient Medication Form for the Wellmeadows Hospital case study shown in Figure (a) Identify the functional dependencies represented by the data shown in the form in Figure. Patient No → Full Name. Appendix B z Other Case Studies. B The Wellmeadows Hospital Case Study This case study describes a small hospital called Wellmeadows, which is located in Edinburgh. The Wellmeadows Hospital specializes in the provision of health care for elderly people.



This case study describes a small hospital called Wellmeadows, which is located in Edinburgh. The Wellmeadows Hospital specializes in the provision of health care for elderly people.

Listed below is a description of the data recorded, maintained, and accessed by the hospital staff to support the management and day-to-day operations of the Wellmeadows Hospital. Wards The Wellmeadows Hospital has 17 wards with a total of beds available for short and long stay patients, and an out-patient clinic. Each ward is uniquely identified by a number for example, ward 11 and also a ward name for example, Orthopaediclocation for example, E Blocktotal number of beds, and telephone extension number wellmeadows hospital case study example, Extn The Wellmeadows 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 Wellmeadows 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 out-patient clinic.

The information stored on each member of staff includes a staff name first and lastfull address, telephone number, date of birth, sex, national wellmeadows hospital case study number NINposition held, current salary, and salary scale. It also includes each members qualifications which includes date of qualification, type, name of institutionand work experience details which includes the name of organization, position, and start and finish dates.

An example of a Wellmeadows Hospital form used to record the details of a member of staff called Moira Samuel working in ward 11 is shown in A. Each ward and the out-patient clinic has a member of staff with the position of Charge Nurse. 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.

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, physiotherapists are allocated to several wards or the clinic. An example of a Wellmeadows Hospital report listing the details of the staff allocated to ward 11 is shown in Figure A. 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 the name first and last nameaddress, telephone number, date of birth, wellmeadows hospital case study, sex, marital status, date registered with the hospital, and the details of the patients next-of-kin. The details of a patients next-of-kin are recorded, which includes the next-of-kins full name, relationship to the patient, address, and telephone number. Local doctors Patients are normally referred to the hospital wellmeadows hospital case study treatment by their local doctor.

The details of local doctors are held including their full name, clinic number, address, and telephone number. An example of a Wellmeadows Hospital patient registration form used to record the details of a patient called Anne Phelps is shown in Figure A.

Patient appointment When a patient is referred by his or her doctor to attend the Wellmeadows 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 patients appointment are recorded, and include the name and staff number of the consultant undertaking the examination, the date and time of the appointment and the examination room for example, Room E As a result of the examination, the patient is either recommended to attend the out-patient clinic or is placed on a waiting list until a bed can be found in an appropriate ward.

Helen Pearson Clinic No. The details of out-patients are stored and include the patient number, name first and last nameaddress, telephone number, date of birth, sex, and the date and time of the appointment at the out-patient clinic. In-patients The Charge Nurse and other senior medical -staff are responsible for the allocation of beds to patients on the waiting list. The details of patients currently placed in a ward and those on the waiting list for a place on a ward are recorded.

Figure A. When a patient enters the ward wellmeadows hospital case study or she is allocated a bed with a unique bed number. An example of a Wellmeadows Hospital report listing the details of patients allocated to ward 11 is shown in Figure A. When a patient is prescribed medication, the details are recorded.

This includes the patients name and number, drug number and name, wellmeadows hospital case study, units per day, wellmeadows hospital case study, method of administration for example, oral, intravenous IVstart and finish date, wellmeadows hospital case study.

The medication pharmaceutical supplies given to each patient is monitored. An example of a Wellmeadows Hospital report used to record the details of medication given to a patient called Robert MacDonald is shown in Figure A.

The Wellmeadows Hospital maintains a central stock of surgical for example syringes, sterile dressings and non-surgical for example, plastic bags, aprons supplies. The details of surgical and non-surgical supplies include the item number and name, item description, quantity in stock, reorder level, and cost per unit. The item number uniquely identifies each type of surgical or non-surgical supply. The supplies used by each ward are monitored.

The hospital also maintains a stock of pharmaceutical supplies for example, antibiotics, pain killers. The details of pharmaceutical supplies include drug number and name, description, dosage, method of administration, quantity in stock, reorder level, and cost per unit.

The drug number uniquely identifies each type of pharmaceutical supply. The pharmaceutical supplies used by each ward are monitored. When required, the Charge Nurse may obtain surgical, non-surgical, and pharmaceutical supplies from the central stock of supplies held by the hospital.

This is wellmeadows hospital case study by ordering supplies for the ward using a requisition form. The information detailed on a requisition form includes a unique requisition number, the name of the member of staff placing the requisition and the number and name of the ward.

Also included is the item or drug number, name, description, dosage and method of administration for drugs onlycost per unit, quantity required, and date wellmeadows hospital case study. When the requisitioned supplies are delivered to the ward, the form must be signed and dated by the Charge Nurse who initiated the order.

An example of a Wellmeadows Hospital requisition form used to order supplies of morphine and tetracycline for ward 11 is shown in Figure A. The details of the suppliers of the surgical, non-surgical, and pharmaceutical items are stored. This information includes the suppliers name and number, address, telephone, and fax number.

The supplier number is unique for each supplier. Each transaction is associated with a specific function within the hospital. These functions are the responsibility of members of staff with particular job titles positions. The main user or group of users of each transaction is given in brackets at the end of the description of each transaction.

Wellmeadows hospital case study Free For 30 Days. Hospital Case Study. Description: : case study. Flag for inappropriate content, wellmeadows hospital case study. Related titles. Carousel Previous Carousel Next. Jump to Page. Search inside document. Staff The Wellmeadows Hospital has a Medical Director, wellmeadows hospital case study, who has overall responsibility for the wellmeadows hospital case study of the hospital. Patients When a patient is first referred to the hospital he or she is allocated a unique patient number.

Patients next-of-kin The details of a patients next-of-kin are recorded, wellmeadows hospital case study, which includes the next-of-kins full name, relationship to the patient, address, and telephone number. Out-patients The details of out-patients are stored and include the patient number, name first and last namewellmeadows hospital case study, address, telephone number, date of birth, sex, and the date and time of the appointment at the out-patient clinic.

Patient medication When a patient is prescribed medication, the details are recorded. Surgical and non-surgical supplies The Wellmeadows Hospital maintains a central stock of surgical for wellmeadows hospital case study syringes, sterile dressings and non-surgical for example, plastic bags, aprons supplies.

Pharmaceutical supplies The hospital also maintains a stock of pharmaceutical supplies for example, wellmeadows hospital case study, antibiotics, pain killers. Ward requisitions When required, the Charge Nurse may obtain surgical, non-surgical, wellmeadows hospital case study pharmaceutical supplies from the central stock of supplies held by the hospital.

Suppliers The details of the suppliers of the surgical, non-surgical, and pharmaceutical items are stored. Abhishek Anand. Dewi Ratna Sari. Manoj Garg. Dudu Innocencia Mmopi. Fauzie Ismail. Simon Dzokoto. Kenny Josef.

Madhesh Ramasamy. Ana Marie Besa Battung. Elisfe Abillar. Harun Al Rasyid. Fire Diki. Dharun Kumar. Thavam Ratna. Stephanie Joy Escala, wellmeadows hospital case study. Cape Town. Muhammad Asghar. Popular in Employment. Devendra Sharma. Sathish Kumar Mgr. Honolulu Star-Advertiser. City Limits New York. Hammad -ullah.

 

 

wellmeadows hospital case study

 

DATABASE DESIGN: NORMALIZATION Q & A Examine the Patient Medication Form for the Wellmeadows Hospital case study shown in Figure (a) Identify the functional dependencies represented by the data shown in the form in Figure. Patient No → Full Name. The Wellmeadows Hospital Case Study. This case study describes a small hospital called Wellmeadows, which is located in Edinburgh. The Wellmeadows Hospital specializes in the provision of health care for elderly people. Listed below is a description of the data recorded. Resource: Appendix B.3, "The Wellmeadows Hospital Case Study" of Database Systems: A Practical Approach to Design, Implementation and Management (6 th edition). Review the case study The Wellmeadows Hospital Case Study" in Appendix B.3 of Systems: A Practical Approach to Design, Implementation and Management.. Develop a Database Security and Optimization Plan for Wellmeadows Hospital .