Mountain View Community Hospital

1
Mountain View CommunityHospital

• Team 1
• Erika Pohl
• Dustin Kemp
• Amber Hallmark
• Darryl Spinks

2
MVCH Introduction

• At the end of each chapter in the textbook,
  Modern Database Management, there is an ongoing
  case study involving the management of a
  simulated database environment. It is designed
  to present a real-world example to better explain
  the concepts and techniques learned by the end of
  each chapter. Databases play a vital role in all
  aspects of life today from supermarkets to car
  dealerships.

3
MCVH Introduction (Cond)

• The case study is based on a simulated
  hospital. Mountain View Community Hospital, or
  MVCH, is a non-profit general hospital. The
  hospital is relatively small with only 150 beds.
  They exist to provide high-quality health care
  for the community while keeping steadily rising
  medical care costs down.

4
MVCH Introduction (Cond)

• MVCHs computer applications support the
  following areas
• - Patient Care administration
• - Clinical Services
• - Financial Management
• - Administrative Services

5
MVCH Introduction (Cond)

• They have purchased most of these applications
  from outside vendors, and some have been
  developed from within MVCH. The applications of
  them are implemented using relational database
  technology. Most of these databases and
  applications are departmental. The databases of
  MVCH contain a number of tables.

6
Hospitals Computer Applications

• Better time management
• Patient History
• Finances
• Communication between departments
• Others

7
Computer Applications

• Client/Server Technology (CRUD)
• CREATE
• READ
• UPDATE
• DELETE

8
Computer Application Classification
Patient
Billing Records
Patient History
Patient Treatment
9
Project Question 1What are some benefits the
hospital should seek in using databases?

• Higher quality data
• Faster and easier access
• Faster development
• Ability to store and retrieve all relevant data
• Reduce program maintenance
• Minimal data redundancy
• Data consistency
• Enforcing Standards

10
Erikas Question

• How can these benefits improve the future of
  MVCH?

11
Relationship Between Patient and Patient Charges
Patient
Patient charges
Billed for
Billed to
12
Project Question 2

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

13
Project Answers 2

• 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 mainly the costs of
  converting older applications to a database
  environment. Alternatively, the hospital may
  choose to purchase new systems from a vendor.
• 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.

14
Project Exercise 2

• Develop a metadata chart (see Table 1-1, Pg 6 of
  text) for data attributes in the PATIENT and
  PATIENT CHARGES table. Use at least those
  columns shown in Table 1-1, but you may include
  other metadata characteristics that you think are
  appropriate for the management of data at MVCH.

15
Metadata Chart
16
Dustins Question

• Of the four major types of databases listed in
  the chapter, (Personal, Workgroup, Department,
  Enterprise) which one(s) would be considered
  useful for the everyday needs of MVCH?

17
Project Question 3

• Mountain View Community is using relational
  database technology, which is appropriate for
  structured data like patient or accounting data,
  but not suited for complex data like graphical
  data and images.

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

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

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

19
Are there other types of database technology that
might be better suited to these data types than
relational?

• An object-relational DBMS would be ideal for MVCH
  since it deals more complex data including
  graphics, sound , images and video.

20
Project Exercise 3
21
Using the data from the tables to fill in the
blank information (shown in red).
22
Ambers Question

• MVCH uses a departmental database application.
  Explain how the personnel department at MVCH
  would use this database.

23
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?

24
Project 4 Answer

• The PATENT 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 3047 has had two
  charges at the moment equaling 1550.

25
Project Question 5

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

26
Question 5 Answer

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

27
Project Exercise 4

• Using the shorthand notation introduced in this
  chapter, draw a single diagram that represents
  the following relationships in the hospital
  environment.
• A HOSPITAL has on its staff one or more PHYSICIAN
  is on the staff of only one hospital.
• APHYSICIAN may admit one or more PATIENTS. A
  PATIENT is admitted by only one PHYSICIAN.
• Each PATIENT may incur any number of CHARGE may
  be incurred by any number of PATIENTS.
• A HOSPITAL has one or more WARDS. Each WARD is
  located in exactly one HOSPITAL.
• A WARD has any number of EMPLOYEES. An EMPLOYEE
  may work in one or more WARDS.

28
Exercise 4 Answer
 
Has
Staffs
HOSPITAL
PHYSICIAN
On Staff
Admits
Admitted by
PATIENT
Incurs
CHARGE
Billed to
Has
WARD
EMPLOYEE
Works in
Located In
29
Project Exercise 5
How would a well managed database help the
hospital achieve its mission? Give some examples
of how the use of databases in the hospital might
improve health care quality or contain costs.
30
Exercise 5 Answer

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

31
Darryls Question
What are some disadvantages of implementing a
first generation database management systems?
32
The End