Mountain View Community Hospital

1
Mountain View Community Hospital

• Case Study
• Group 1
• Michael Shumate
• Sheena Clark
• Tommy Rohlfing
• Phil Amuzu

2
Mountain View Community Hospital

• We will be discussing a case study at the end of
  each chapter of our text book Modern Database
  Management. The case study involves a hospital
  which is known as Mountain View Community
  Hospital, or MVCH for short. In this case study
  we will be looking at the hospitals database
  system and how improvements can be made.

3
MVCH continued

• MVCH is a non-profit, short-term, acute care
  general hospital. It is a small hospital with
  about 150 beds at the present time. The basic
  goal is to provide high-quality health care in
  the surrounding area, while at the same time
  containing costs that have been rising in
  accordance with national trends in recent years.

4
MVCH continued

• MVCHs computer applications support several
  things, some of which include patient care
  administration, clinical services, financial
  management , and administrative services. Most of
  these have been purchased through outside
  vendors, but have been developed internally. Most
  of the databases and applications are
  departmental.

5
Project Question 1

• What are some of the important benefits that MVCH
  should seek in using databases?

6
Project Question 1

• MVCH should seek the following benefits of a
  database.
• Be able to develop the database faster.
• Also to enforce certain standards and cut down on
  minimal data redundancies.
• Higher quality data that is faster and easier to
  access
• Be able to store and retrieve all important
  information.

7
Project Exercise 1

• Billed for Bi
  lled to

8
Michaels Question

• How can the benefits that MVCH are seeking (using
  databases) be beneficial for their hospital?

9
Project Question 3

• In our study, Mountain View Community Hospital is
  using relational database technology. Although
  this technology is appropriate for structured
  data such as patient or accounting data, it is
  less well suited to complex data such as
  graphical data and images.

10

• What types of data are used by a hospital that
  fit in the complex data category?
• Documents (admission forms, physician referrals,
  etc.)
• Medical Scans (MRI, X-ray, etc.)
• Unstructured Text (doctors orders, doctors
  notes, etc.)
• Test Results (electrocardiograms, ultrasounds,
  etc.)
• Clinical Test Data (blood test, etc.)

11

• What type of Database technology might be better
  suited to these data types than relational?
• An object-relational database management system
  would be better for MVCH since it deals with more
  complex data including graphics, sound, images,
  and video.

12
Project Question 4

• How are the data in the PATIENT and PATIENT
  CHARGES table related?(How can a user find the
  relevant charges for a particular patient?)

13
Answer to Project Question 4

• The PATIENT and PATIENT CHARGES tables are tied
  together by the Patient_Number attribute in
  common so you can pull the charges for a
  particular patient by using the patients number.
• (You will see an example shortly)

14
Project Exercise 3

• An important database view for the hospital is
  the Patient Bill.
• Fill in the missing data in this view, using
  the data from Figure 1 on page 33.

15
Patient Bill
16
Patient Bill
17
Tommys Question
Using Figure 1 on Page 33, find the total
amount of charges due for Annette Larreau.
18
Project Question Two

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

19
Project Answers Two

• New, specialized personnel. This will include
  database designers, database administrators, and
  other skills that are in short supply in a tight
  job market.
• Installation and management cost and
  complexity. This may include installing a new
  DBMS as well as hardware and operating system
  upgrades.
• Conversion to the new system will be extra
  expense. These are primarily the costs of
  converting older applications to database
  environment. Alternatively., the hospital may
  choose to purchase new system from a vendor.
• Need for explicit backup and recovery. These are
  the system cost associated with backup and
  recovery procedures.
• Organization conflict. The hospital must
  anticipate the cost of data definitions,
  ownership, and maintenance.

20
Project Exercise Two

• Create a metadata chart( see table 1.1, pg 6 of
  text) for data attribution in the PATIENT and
  PATIENT CHARGES table.
• Use at least those columns shown in the table
  1.1, but you may include other metadata
  characteristics that you think are appropriate
  for the management of data at MVCH.

21
Metadata Chart
22
Phils Question

• Out of the four database applications activities
  listed below and in the chapter (create, read,
  update and delete) which one(s) would be
  considered useful for the everyday activity of
  MVCH?

23
Project Question 5

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

24
Project Question 5 Answer

• Improved customer information and service
• Use Intranet to provide faster and more efficient
  processing or access to information
• Universal access for hospital personnel
• Extranet for insurance companies to do third
  party

25
Project Exercise 5

• How would a well-managed database help the
  hospital achieve its mission? Give examples of
  how the use of databases in the hospital might
  improve health care quality or contain costs.

26
Project Exercise 5 Answer

• Developing records of treatment programs, will
  show which programs are the most effective
• Tracking cost that are operating, will show which
  costs are rising above the average.
• Providing information to keep track of how long a
  patient stays, will give hospital cost per day
• Providing medical records on patients, will show
  doctors relevant information and could be changed
  if necessary

27
Sheenas Question

• How could MVCH incorporate use of the Internet
  into everyday operations?