Scribd Logo
Upload

Welcome to Scribd!

  • 813 views

    Case Study For Hdbms

    Uploaded by

    Mohammed ABDO ALBAOM
    A database management system (DBMS) could help Wellmeadow Hospital manage patient and administrative data more efficiently. Currently, the hospital relies on paper forms with redundant information. A DBMS would allow the hospital to [1] define its key data needs and relationships, [2] prioritize systems implementation in a phased approach, and [3] improve data consistency, speed, and security. The document outlines relevant data categories including staff, patients, supplies and operations. It presents sample data relationships and queries that a DBMS could support for the hospital.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Case Study For Hdbms

    Uploaded by

    Mohammed ABDO ALBAOM
    813 views5 pages
    A database management system (DBMS) could help Wellmeadow Hospital manage patient and administrative data more efficiently. Currently, the hospital relies on paper forms with redundant information. A DBMS would allow the hospital to [1] define its key data needs and relationships, [2] prioritize systems implementation in a phased approach, and [3] improve data consistency, speed, and security. The document outlines relevant data categories including staff, patients, supplies and operations. It presents sample data relationships and queries that a DBMS could support for the hospital.

    Original Title

    Case Study for Hdbms

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    A database management system (DBMS) could help Wellmeadow Hospital manage patient and administrative data more efficiently. Currently, the hospital relies on paper forms with redundant information. A DBMS would allow the hospital to [1] define its key data needs and relationships, [2] prioritize systems implementation in a phased approach, and [3] improve data consistency, speed, and security. The document outlines relevant data categories including staff, patients, supplies and operations. It presents sample data relationships and queries that a DBMS could support for the hospital.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    813 views5 pages

    Case Study For Hdbms

    Uploaded by

    Mohammed ABDO ALBAOM
    A database management system (DBMS) could help Wellmeadow Hospital manage patient and administrative data more efficiently. Currently, the hospital relies on paper forms with redundant information. A DBMS would allow the hospital to [1] define its key data needs and relationships, [2] prioritize systems implementation in a phased approach, and [3] improve data consistency, speed, and security. The document outlines relevant data categories including staff, patients, supplies and operations. It presents sample data relationships and queries that a DBMS could support for the hospital.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    Case Study: Hospital Databases Management System

    In what ways would DBMS help the Hospital? Wellmeadows Hospital serves a verity of clients for medical procedures, and employs a full staff of professional and administrative personnel. Currently the hospital is managed through paper forms, many of which require elements of the same information, so this case study exploring the HDBMS ways, needs, queries and the relationships that exist between the data.

    A database management system (DMMS) can help Wellmeadow Hospital and identify the needs to be represented in database in many ways: In defining database requirements for the hospital staff,clients ,setup and processes, the hospital can be better identify its business and examine its strengths and weaknesses , in the effect analysis for the database can become an opportunity to examine and improve the business as a whole. Because a DBMS requires a considerable investment of time and money , the hospital has an opportunity to prioritize its needs, with a phased approach to systems implementation the hospital can focus on identifying (and reengineering if needed) core functions first . The structure of a DBMS forces the hospital to clarify data needs, enforces data consistency, eliminates redundancy, and reduces error. In the time sensitive, privacy focused world of hospital operations, needs the speed and security of a DBMS can literally and figuratively save lives.

    Relevant data
    Here are the main categories and subcategories of data Wellmeadows Hospital:

    Staff
    Medical Director Personnel officer Charge nurses Physicians Auxiliaries Specialists

    Patients

    Inpatient Outpatient

    Words
    Beds
    Supplies
    Surgical Nonsurgical Pharmaceutical

    Operations

    Appointments Registrations Supply requisitions Staff assignments Employment contracts Budgets

    Data Relationships
    The Operations section of the data list is a good starting point for defining data relationships that allow existing between the data, that is, how the different sectors interact. Here's a diagram of the main data relationships:

    In brief: 1. 2. 3. 4. 5. Patients make appointments with staff Patients register for a hospital stay in a ward Patients need prescription medication Staff are assigned to wards Wards are responsible for ordering supplies

    And here some queries, I think are required: Patient Check In / Check Out. Laboratory / Pathology Automation. Inventory System. Medicine. Patient Record Maintenance. Staff Record Maintenance. Staff Payroll System. Doctor Consultant. Laundry Maintenance System. Emergency Services. Operation Room / ICU Maintenance. In-house Mailing System. Blood Bank Maintenance System. Database of Blood Donors / Blood Group. Billing System. Communication of different Group Hospitals (If Any) Infrastructure Maintenance. Medical Equipment Maintenance.

    References
    carolemillz (2010) Hospital Management System - Research Papers - Carolemillz. [online] Available at: http://www.oppapers.com/essays/Hospital-Management-System/850874 [Accessed: 24 Jun 2012]. Student.gsu.edu (2008) Exercise 1 | CIS 8040 | Shannon K. Orr. [online] Available at: https://www.student.gsu.edu/~sorr4/CIS8040/Ex1.htm [Accessed: 24 Jun 2012].

    You might also like