Mountain View Community Hospital

1
Mountain View Community Hospital

• George Hannah
• Nakisa Walker
• Sarah Branscum

2
Introduction

• Mountain View Community Hospital is discussed at
  the end of each chapter in case study formats.
  MVCH has computer applications that support
  several areas. For example patient care
  administration, clinical services, financial
  management, and administrative services. Most of
  the computer applications use relational database
  technology.

3
Introduction

• The applications have been purchased by outside
  vendors, with a few developed inside the
  organization. Most of the databases and the
  applications are departmental and contain a
  number of detailed tables.

4
Introduction

• Mountain View Community Hospital is a relatively
  small hospital with about 150 beds. MVCH is
  non-profit and handles short term, acute care.
  Their goal is to provide high quality care to its
  area patients while at the same time trying to
  keep the costs relatively contained.

5
Project Question 1

• What are some of the important benefits that
  Mountain View Community Hospital should seek in
  using databases?

6
Project Question 1 Solution

• Storage and Retrieval ability of patient records
• Faster and Easier access to information
• A higher quality of data including less
  redundancy and improved standards
• A quicker development of new applications

7
Project Question 2

• What are some of the costs and risks of using
  databases that the hospital must manage carefully

8
Project Question 2 Solution

• The risk of information loss would require a need
  for backup and recovery devices
• Organizational conflict involving employees who
  support the new applications and those that do
  not
• Cost of conversion from the old system to the new
  system
• Installation and management costs for supporting
  the new system like new hardware, software, and
  operating system upgrades
• New specialized personnel from database
  designers, administrators and others

9
Project Question 3

• What are some types of data maintained by a
  hospital that fit into the category of images and
  graphical data? What types of database
  technology might be better suited to these data
  types than relational

10
Project Question 3 Solution

• Medical Scans (MRIs and X-Rays)
• Clinical test data (Blood and Drug)
• Documents (Admission forms)
• Unstructured text (Doctors notes)
• Test results (Electrocardiograms, Ultrasound)

11
Project Question 4

• How are data in the patient and patient charges
  tables related? That is how can a user find the
  relevant charges for a particular patient?

12
Project Question 4 Solution

• The PATIENT and PATIENT CHARGES tables are linked
  by the Patient_Number attribute which is common
  to both tables. Thus for example patient no.
  54321 has had three separate charges at the
  present time.

13
Project Question 5

• What are some ways the hospital could use the
  Internet?

14
Project Question 5 Solution

• Mountain View Community Hospital could use
  Internet technology to establish an Intranet for
  access to databases by internal hospital
  personnel. Also, the hospital could investigate
  an Extranet application to do third-party billing
  directly with insurance companies. Another
  application of the Internet would be to enable
  access to medical databases and prescription drug
  databases that are available online.

15
Project Exercise 1

• Patient and Charges Relationship Diagram

16
Project Exercise 2

• Metadata Chart Data attributes of patient and
  patient charges tables

17
Project Exercise 3
18
Project Exercise 3Answer
19
Project Exercise 4Diagram to show relationships
in the hospital environment
20
Project Exercise 5

• How would a well-managed database help the
  hospital achieve its mission to provide
  high-quality health care for its surrounding
  community, while containing rising costs?

21
Project Exercise 5 Solution

• Develop historical records of treatment programs,
  to identify which programs and procedures are
  most effective and which are not
• Tracks operating cost, and identify costs that
  are rising or are above average for similar
  hospitals
• Provide data and information to track important
  measures such as average length of patient stay,
  cost per day for a patient
• Provide an electronic medical record for each
  patient, so that physicians can quickly assemble
  all relevant information

22
Sarahs Question

• What are some disadvantages of the MVCH
  traditional filing system that a database will
  solve.  Explain how these can be solved?

23
Georges Question

• The hospital uses a department database. What
  are the different ways the personnel department
  could use this type of database?

24
Nakisas Question

• Types of databases include personal, workgroup,
  department, enterprise, internet, extranet, and
  intranet. Which type(s) could MVCH use to get
  the most benefit from databases?