Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Mountain View Community Hospital

Group 4 Project
by

Linda Ol

on 10 December 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Mountain View Community Hospital

MIS 675 - Database Managment Systems
Case Question 1
The goal of Mountain View Community Hospital is to provide high-quality, cost-effective health-care services for the surrounding community in a compassionate, caring, and personalized manner. Give some examples of how the use of databases in the hospital might improve health-care quality or contain costs. How else could a well-managed
database help the hospital achieve its mission?
Answer

Case Question 3
Answer
What are some of the costs and risks of using databases that the hospital must manage carefully?
Case Question 6
Equipos médicos
Case Exercise 1
Group 4
Ernie Agbobock
Dominique Hosea
Lenna' Myles
Linda Olisa

Mountain View Community Hospital
Hospital should carefully manage some of the cost and risk of using database because in a job market, there is short supply of skills such as database designer and database administrator. Without the specific faculty, it creates a risk to manage the database. The installation and administration expenses include updating software and installing of database and hardware. The translation cost includes the converting cost of older application into database environment. Instead of converting the hospital can choose new system. There is a need for the backup and recovery because the framework expenses are connected with those strategies. A hospital must predict the data administration cost and other activities cost related to data definition, ownership and maintenance.
A decently overseen database may help the healing center accomplish its mission by the following points:
• Cost of the each treatment in similar hospital is stored in the database to compare rate with other hospital.
• Physicians can gather the relevant information quickly by providing the electronic medical record for each patient.
• To find which programs and methods are best, create a historical record of the treatments.
• Track the important measure to provide the data and information for example, normal length of patient wait, price for each day for a patient.

Mountain View Hospital could use web based applications in a few ways.
• Internet hospital personnel uses web based applications to create an intranet to access the databases.
• Extranet application is used to third party billing with the insurance companies so hospital examines the application.
• Online application permits to access the medical database and prescription drug database.
The major advantage of web based application is reorganization that practice as a third party billing and the disadvantage is security. If the network security allows the unauthorized user, then the data available in internet creates the security problem.

Mountain View Hospital
Data
Quality
Data quality in the hospital is highly critical because that is what shows the doctors, nurses, accountants all information on the patient.
The quality of the data should be presented in a manner that when presented in a chaotic environment, the information is not one of the things contributing to the chaos.
Some data requires to have more quality restrictions that have to be complied with, such as x-rays/CT-scans/mammograms which determine more than just an illness; these could determine life and death information, therefore, databases have to make sure that the quality is not compromised, even over the network.

How could the hospital use Web-based applications? What
are some of the benefits and risks associated with Webbased
applications for the hospital?
The relational databases at Mountain View Community Hospital contain a number of tables. Two of these tables, with some sample data, are shown in MVCH Figure 1-4. The PATIENT table contains data concerning current or recent patients at the hospital, whereas the PATIENT CHARGES table contains data describing charges that have been incurred by those patients. Interestingly, the PATIENT CHARGES table is not captured in the preliminary enterprise data model shown in Figure 1-3.
a.
Case Exercise 6
• First we determine the packaged information system present for risk management.
• The solution could be a combination of prototyping and life cycle approaches.
• Next identify entities and relationships involved in the desired risk management system.
• After this an interim prototype of the risk management system can be built if the manager decides necessary.
• Next project initiation and planning.
• Now an iterative cycle of analysis, design and implementation can be used by developers.
• The system will use a database of limited scope until integrated to a complete system.

Case Exercise 6 and 7
Database Interface
Database is useless without interface.
Allow people to find the information they need quickly
bad user interfaces make it difficult or even impossible
There are several types of Interface
Menu-Based Interfaces for Web Clients or Browsing
Forms-Based Interfaces
Graphical User Interfaces
Natural Language Interfaces
Interfaces for Parametric Users
Interfaces for the DBA
The Components of Database Environment
Interfaces for the DBMS

Systems contain privileged commands only for DBMS staff.
Include commands for creating accounts, setting parameters, authorizing accounts, changing the schema, reorganizing the storage structures etc.
ER Model
Access Tables
Questions??
6.
• First we determine the packaged information system present for risk management.
• The solution could be a combination of prototyping and life cycle approaches.
• Next identify entities and relationships involved in the desired risk management system.
• After this an interim prototype of the risk management system can be built if the manager decides necessary.
• Next project initiation and planning.
• Now an iterative cycle of analysis, design and implementation can be used by developers.
• The system will use a database of limited scope until integrated to a complete system.


7. The unstructured and unpredictable data should be used because they do not interfere with operational database access.

P2. Treatment view, Physician View, Laboratory View, Pharmacy View, Nurse_Supervisor View, Care Center View, Lab Supervisor View.
P3. (a)
(b) A volunteer volunteers at one or more facilities.
A facility has one or more volunteers.
A facility uses one evacuation location.
An evacuation location is used by many facilities
.

P3. (c)
Case Exercise 6 and 7
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. Mountain View Community Hospital (MVCH) wants to provide better services than their current deliverables. Therefore, databases can help MVCH reach their goal through making relational applications provide information about clients or patients without having a book or paperwork to search for every time.
Mountain View Hospital Introduction
MVCH Introduction
MVCHs computer applications support the
following areas
- Patient Care administration
- Clinical Services
- Financial Management
- Administrative Services
Hospitals Computer Applications
Better time management
Patient History
Finances
Communication between departments
Others
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
Interfaces for the DBMS

Systems contain privileged commands only for DBMS staff.
Include commands for creating accounts, setting parameters, authorizing accounts, changing the schema, reorganizing the storage structures etc.
Full transcript