Mountain View Community Hospital

1
Mountain View Community Hospital

• Group 2B
• Michael Glover
• Amanda Cooper
• Justin Neff

2
Project Description

• The hospital has established a set of 10
  preliminary entity types that describe the data
  required by the hospital for its operation and
  administration

• Facility
• Physician
• Patient
• Ward
• Staff

• Laboratory
• Test
• Medical/Surgical Items
• Supply Item
• Vendor

3
Project Description

• The study team developed the following business
  rules which govern the relationships between
  those entities.
• A FACILITY maintains a number of LABORATORY(ies).
• A FACILITY contains a number of WARDs.
• Each WARD is assigned to a certain number of
  STAFF members a STAFF member may be assigned to
  multiple WARDs.
• A FACILITY staffs its medical team with a number
  of PHYSICIANs. A PHYSICIAN may be on the staff of
  more than one FACILITY

4
Project Description

• A PHYSICIAN treats PATIENTs, and a PATIENT is
  treated by any number of PHYSICIANs.
• A PHYSICIAN diagnoses PATIENTs, and a PATIENT is
  diagnosed by any number of PHYSICIANs.
• A PATIENT may be assigned to a WARD.
• A PATIENT uses MEDICAL/SURGICAL ITEMS, which are
  supplied by VENDORs. A VENDOR also provides
  SUPPLY ITEMs that are used for housekeeping and
  maintenance purposes.
• A LABORATORY performs TESTs about PATIENTs.

5
(No Transcript)
6
Project Description

• The study team used a CASE tool to design the
  function-to-data entity matrix, which shows the
  relationship between the business functions and
  the 10 data entities. (Figure 4, p.70)
• M function maintains instances of entity
  (creates, updates, and deletes)
• R function uses data about entity

7
(No Transcript)
8
Project Description

• Next the CASE tool was used to relate the
  business functions to the four critical success
  factors (CSF)
• Quality Care
• Operating Cost Control
• Capital Cost Control
• Staff Recruitment and Retention
• E function essential in achieving CSF
• D function desirable in achieving CSF

9
(No Transcript)
10
Project Question 6

• Do you think that the study team will be able to
  identify all the data entities by doing the kind
  of analysis they have been doing?
• If not, what other database development steps
  will need to be done and when?

11
Project Question 6 Answer

• No. Since there is not a representative from each
  department, it is possible that some entities
  could have been overlooked.
• Explaining the function-to-entity matrix to
  employees in each department to allow them to
  identify any entities that have been overlooked.
• This can be done during the enterprise data
  modeling phase, which is done during the
  information systems planning.

12
Project Question 7

• Why do you think the people on the business
  planning study team were selected for this
  assignment?
• Would you have chosen different or additional
  people?

13
Project Question 7 Answer

• These people were selected because of their
  expertise in their selected fields.
• Additional team members can always be used in
  this type of study to ensure multiple
  perspectives are considered.

14
Project Question 8

• In the case description above, nine business
  rules are listed. The study team used these
  rules to develop Figure 3.
• What other business rules, besides these nine,
  are implied by or depicted by Figure 3?

15
Project Question 8 Answer

• Each FACILITY maintains any number of
  LABORATORIES.
• Each WARD has any number of PATIENTs assigned to
  it.
• A SUPPLY ITEM may be provided by any number of
  VENDORs.
• A MEDICAL/SURGICAL ITEM may be used by one or
  many PATIENTs.

16
Project Question 9

• Even though capital cost control is a critical
  success factor, only two business function in
  Figure 5 mention this CSF. Why?
• What would need to be done to enhance this figure
  so that more entries indicated a relationship
  between business functions and this CSF?

17
Project Question 9 Answer

• Both Electrodiagnosis and Surgery require large
  capital investments to make them successful, and
  are both also highly technologically dependent.
• By adding a neutral or N status signaling that
  the function is not of significant importance in
  achieving the CSF.
• Thus functions such as Physician Orders and
  Personnel are not significant in achieving
  capital cost control.

18
Project Exercise 5

• One of the important outputs from the bill
  patient business function is the Patient Bill.
  Verify the enterprise data model in Figure 3
  contains the data necessary to generate a patient
  bill.
• Explain what you would have to do to perform this
  verification. What did you discover from your
  analysis?

19
Project Exercise 5 Answer

• Since the enterprise data model only shows the
  entities involved, we are only able to determine
  whether each entity is represented.
• The patient bill needs to be updated to include
  information such as the physician name, room
  number, and total amount charge.
• Some attributes may need to be modified to
  eliminate confusion or avoid misinterpretation.

20
Project Exercise 6

• The study team activities described in this case
  study have related to very early stages of
  information systems and database development.
• Outline the next steps that should be followed
  within the information systems unit to align
  current systems and databases to the future
  information systems needs of the hospital.

21
Project Exercise 6 Answer

• The team is ready to consider the necessary
  requirements for integrating into the proposed
  expansion system the two new departments of
  Retirement Living, and Geriatric Medicine.
• After the entire enterprise data model is
  constructed, the subsystems should be identified
  and prioritized to allow them to move on to the
  conceptual data model.

22
Project Exercise 7

• The hospital is increasingly facing malpractice
  claims and litigation, and the risk management
  manager does not believe he can wait for improved
  information services until the information
  systems and database plans are set.
• How would you proceed to deal with this request
  for improved information services?
• What methodology would you apply to design the
  systems and databases he needs? Why?

23
Project Exercise 7 Answer

• After the enterprise model has been agreed upon,
  it will be possible to identify the entities and
  relationships necessary to create the desired
  risk management system.
• Now by combining prototyping and life cycle
  approaches, a prototype of the new risk
  management system could be built and implemented
  to fill the managers needs.

24
Project Exercise 7 Answer cont.

• This will be used as a working prototype which
  can be updated as the system design progresses
  until it fully integrates into the new
  information system.

25
Project Exercise 8

• Consider again the request of the manager of risk
  management from Project Exercise 7. On what tier
  or tiers would you recommend the system and
  database he needs be developed? Why?

26
Project Exercise 8 Answer

• The database should be setup on the client tier
  as a stand-alone database in the risk management
  department since the information contained within
  the database is of a confidential nature.
• Once the entire enterprise system is completed,
  the risk management database will be integrated
  into the enterprise server tier.