Mountain View Community Hospital

1
Mountain View Community Hospital

• Chapter 4 Presentation
• Brad Fisher
• Latoya Gates
• Ian Marvel

2
Introduction

• Hospital is dependent on four types of people
  physicians, employees, patients, and volunteers
• They have common attributes such as Name,
  birth_date, People_ID(an indentifier) and Phone.

3
Introduction

• Each of the 4 types has a unique attribute
  associated with it.
• Physicians Specialty and Pager Number
• Employees Date_Hired
• Patients Contact Date
• Volunteers Skill

4
Introduction

• Some people may not belong to a group, while
  others may belong to two or more groups
  simultaneously.
• Each patient has only one physician.
• A physician may not be provide care to a patient
  or may provide care for one or more patients.
• Patients are divided into two groups Outpatient
  and resident.

5
Introduction

• Each patient has a Date _Admitted attribute.
• Each outpatient is scheduled many or none visits.
  The entity visit has two attributes Comments and
  Date.
• The entity visit can not exist without the strong
  entity Outpatient.

6
Introduction

• Employees are divided into three groups nurse,
  staff, and technician.
• Nurse has a Certificate attribute, staff has a
  Job_Class attribute, and Technician has a Skill
  attribute.
• Each nurse is assigned to one care center.

7
Introduction

• Attributes of the care centers are Name
  (identifier) and Location.
• A care center may have one or many nurses
  assigned to it.
• For each care center, one of the nurses is
  appointed as Nurse_In_Charge.

8
Introduction

• Each technician is assigned to either one or many
  labs.
• Attributes of labs include Name (Identifier) and
  location.
• A lab must have at least one technician but could
  have more.

9
Introduction

• A care center may be assigned zero or many beds.
• Bed_ID is the only attribute associated with bed.
  It can also be broken down into a composite
  attribute.
• Components of Bed_ID include Bed_No and Room_No.
• Each resident must be assigned a bed.
• A bed either may or may not be assigned to anyone
  at a given time.

10
MVCH Project Question 1

• Is the ability to model supertype/subtype
  relationships likely to be important in a
  hospital environment such as MVCH? Why or why not?

11
Project Question 1 Answer

• Yes, the ability to model supertype/subtype
• relationships is probably very important to a
• hospital environment. With specialization,
• entities for a hospital would be subtypes.
• Examples on the next slide

12
Project Question 1 Answered (Continued)

• Item Subtypes would be Prescription Item and
  Supply_Item
• Patient such subtypes like InPatient and
  Outpatient.
• Test Subtypes like Scan and Blood Test.
• Procedure Subtypes like Surgical and Biopsy.

13
Project Question 2

• Can the business rules paradigm and the ability
  to easily define, implement, and maintain
  business rules be used a competitive advantage in
  a hospital environment such as MVCH? Why or why
  not?

14
Project Question 2 Answer

• Yes, the business rules make it possible for a
  business to change its process and procedures
  rapidly in response to a rapidly changing
  environment.

15
Project Question 3

• Do there appear to be any weak entities in the
  description of the data requirements in this
  project segment? If so, what are they?

16
Project Question 3 Answer

• Yes, VISIT is a weak entity. In order for it to
  exist as an entity it must be bound to a strong
  entity, like Outpatient.

17
Project Question 4

• Can you think of any business rules (other than
  the one explicitly described in the case) that
  are likely to be used in a hospital environment?

18
Project Question 4 Answer

• There are many business rules involved with a
  hospital. Two examples are the following
• A. A patient cannot be admitted to the
  hospital without a referral from a responsible
  physician.
• B. A nurse can only be reassigned to a different
  care center if the nurse is given permission from
  the nurse in charge of the current care center
  that the nurse is assigned to.

19
Project Question 5

• Would you recommend using a packaged data model
  to begin development on the Mountain View
  Community Hospital project? Why or why not?

20
Project Question 5 Answer

• Yes, I would recommend using the packaged data
  model because the entities are connected to the
  highest level entity type in an hierarchy that
  makes sense. This allows relationships to be
  added , deleted, or renamed when it is necessary.
  The package data model is also designed so that
  the relationships can be tracked over time. All
  the supertype/subtype relationships follow the
  total specialization and overlap rule.

21
Project Question 5 Answer (continued)

• This design makes the diagram as flexible and
• thorough as possible. The design also shows that
• most of the entities on the many side are
• weak entities, therefore the identifier of the
  strong
• entity is inherited to the weak entities
  ,according to
• the packaged data model,.

22
Project Exercise 1

• Draw an EER diagram to accurately represent this
  set of requirements, carefully following the
  notation from this chapter.

23
(No Transcript)
24
Project Exercise 2

• Develop definitions for each of the objects in
  your EER diagram from Project exercise 1. Consult
  with some member of the hospital or health care
  community if one is available Otherwise make
  reasonable assumptions based
• on your own knowledge and experience.
• Entity Types
• Attributes
• Relationships

25
Project Exercise 2 Answer

• Definitions
• Entity Types
• Physician- A person skilled in the art of
  healing
• A doctor of medicine.
• Patient- An individual under medical care
  and
• treatment.

26
Project Exercise 2 Answer (continued)

• Employee- one employed by another usually for
  wages or salary and in a position below the
  executive level.
• Care Center- An organization that performs a set
  of services toward patient care.
• B. Attributes
• Person_ID- the persons social security number.
• Birth_Date- month, day, and year a person was
• born.

27
Project Exercise 2 Answer (continued)

• Specialty- a physician/s specific area of
  practice.
• Location- hospital wing and floor number for a
  care center.
• C. Relationships
• Assigned- an association between a patient and a
• hospital bed.
• Scheduled- association between an outpatient and
• A specified visit to the hospital.

28
Project Exercise 3

• You should recognize the statement A nurse
  cannot be appointed nurse_in_charge of a care
  center unless she or he has an RN certificate as
  a statement of a business rule. Answer the
  following questions.
• What is the anchor object? Is it an attribute, a
• relationship, or some other object?
• B. What is the corresponding object (or objects,
  if
• more than one)? Is it an entity, an attribute, a
• relationship, or some other object?

29
Project Exercise 3 Answer

• The anchor object for this statement is Nurse,
• which is an entity in the EER diagram. The
• corresponding object is RN Certificate, which
  also
• is an entity in the EER diagram.

30
(No Transcript)
31
Project Exercise 5

• Merge the two diagrams from Project exercise 4
  and from Project exercise 2 in chapter 3 into a
  single diagram. Explain decisions you make during
  the merging.

32
(No Transcript)
33
Brad Fishers Question

• "Why does the PERSON entity have many attributes
  related to location while other entities simply
  have a single attribute named location? Should
  they be multi-valued?"

34
Ian Marvels Question

• Why does date act as a partial identifier
  attribute of Visit?

35
Latoya Gates Question

• What is a generalization?  Name one
  generalization used in the MVCH case and explain
  why.