Mountain View Community Hospital

1
Mountain View CommunityHospital

• Team 1
• Johnny Moore
• Richard Johnson
• Kevin Flory

2
Mountain View Community Hospital

• At the end of each lesson, there is a
  repetitious case study involving the management
  of a simulated database environment. This is
  designed to present simulated examples to better
  explain the concepts and techniques learned by
  the end of each chapter. Databases are
  everywhere and are involved in everything. They
  play a vital role in all aspects of life today
  from restaurants to hospitals.

3
MCVH (Contd)

• The case study is based on a simulated hospital.
  Mountain View Community Hospital is a small
  free-will general hospital. Their main objective
  is to provide all of the valued customers with
  high-quality health care and support services,
  while keeping the rising cost of medical care to
  a minimum.

4
MVCHS computer applications support the
following departments

• PATIENT CARE ADMINISTRATION
• Better time management
• CLINICAL
• Patient history
• FINANCIAL
• Finances
• ADMINISTRATIVE
• Communication between departments

5
MVCH DATABASE APPLICATIONS

• CLIENT/SERVER TECHNOLOGY OR (CRUD)
• CREATE
• READ
• UPDATE
• DELETE

6
What are some benefits Mountain View Comm. Should
seek in using databases?

• Higher quality data
• Faster access and development
• Ease of access
• Storage of relevant data and its retrieval
• Reduced maintenance
• Minimal redundancy
• Consistency
• Enforcing standardization

• Project Question 1

7
What are some costs and risks Mountain View must
manage carefully while using databases?

• New, specialized personnel This would include
  designers,administrators and others who may be 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 costs Are the costs of converting
  from older applications to a database
  environment. It may be sufficient for the
  hospital to purchase new systems from a vendor.
• The need for explicit backup and recovery These
  are the system costs associated with backup and
  recovery procedures.
• Organizational conflict The hospital must
  anticipate the costs of data administration and
  other activities related to developing a
  consensus on data definitions, ownership, and
  maintenance.

Project Question 2
8
Johnny Moore

• MVCH is using a database technology, which is
  appropriate for structured data such as patient
  or account data, but not suited for complex data
  like graphical data and images.

9
What types of data are maintained by a hospital
that fit this category?

• Unstructured text
• Doctors orders, doctors notes, etc.
• Test results
• Electrocardiograms, ultrasounds

• Medical scans
• MRI, X-ray, etc.
• Clinical test data
• Blood test, etc.
• Documents
• Admission forms, Physician referrals

Project Question 3
10
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?

• The PATIENT CHARGES tables share the attribute
  Patient-number. Using this, one could
  cross-reference the data in the two tables to
  come up with information about a particular
  customer. For example, customer 4238 has had
  three charges at the moment equaling 1,950.

Project Question 4
11
What are some ways the Mountain Valley Community
Hospital could use the internet?

• They could establish an Intranet for access by
  hospital personnel.
• Set up an extranet application to do third-party
  billing with insurance companies.
• Easy access to medical databases and prescription
  drug databases that are available online.

Project Question 5
12
Relationship Between Patient and Patient Charges

• Project Exercise 1

Patient
Patient charges
Billed for
Billed to
Project Exercise 1
13
Metadata Chart
Project Exercise 2
14
PATIENT
Project Exercise 3
PATIENT CHARGES
15
Using the previous tables to fill in the blank
information (shown in RED)
Project Exercise 3
16
Relationships in the hospital environment
Has
Staffs
HOSPITAL
PHYSICIAN
On Staff
Admits
Admitted by
CHARGE
PATIENT
Incurs
Billed to
WARD
EMPLOYEE
Has
Works In
Located In
Project Exercise 4
17
How would a well managed database help Mt. View
Comm. Hospital achieve its mission?

• Tracks and identifies costs that are rising for
  the hospital
• Quickly assembles all relevant information
  pertaining to patients medical records for
  physicians use
• Assists in the development of various treatment
  programs and procedures which historically are
  most effective
• Provides tracking information of patient costs
  and expenses, providing a measurement for cost
  cutting measures

Project Exercise 5
18
Which of the four major types of databases that
were reviewed in the chapter would be most useful
to Mountain View Community Hospital?
Richards Question
19
If these benefits are implemented, how can the
improve the future of Mountain View Community
Hospital?
Johnnys Question
20
Mountain View Community Hospital uses a
departmental database application. Explain how
the personnel department at MVCH use this
particular database?
Kevins Question
21
The End