Mountain View Community Hospital

1
Mountain View Community Hospital

• Chapter 4
• TR 800 Section

Brandon Freeman Lanny Heidbreder Jason Payne
2
Introduction

• Groups of PERSONs
• Employees
• Physicians
• Patients
• Volunteers

• Common Attributes
• Person_ID
• Name
• Address
• City
• State
• ZIP
• Birth_Date
• Phone

3
Introduction

• Attributes unique to each gr0up
• Employees
• Date_Hired
• Volunteers
• Skill
• Physicians
• Specialty
• Pager
• Patients
• Contact Date

4
Introduction

• Groups of PERSONs
• Employees
• Physicians
• Patients
• Volunteers
• NOT mutually exclusive

• Common Attributes
• Person_ID
• Name
• Address
• City
• State
• ZIP
• Birth_Date
• Phone

5
Introduction

• Stuff about PATIENTs
• Cardinality with DOCTORs
• One doctor per patient
• Zero or more patients per Doctor
• Subtypes
• RESIDENT
• Date_Admitted attribute
• OUTPATIENT
• Scheduled for zero or more VISITs

6
Introduction

• Stuff about VISITs
• Attributes
• Date
• Comments
• A visit cant exist without an OUTPATIENT.
• Identifier OUTPATIENT (owning entity) date

7
Introduction

• Stuff about EMPLOYEEs
• Three kinds of em
• Nurse
• Attribute Certificate (nurses have to have one)
• Assigned to one (and only one) CARE CENTER.
• Staff
• Attribute Job_class
• Technician
• Attribute Skill

8
Introduction

• Stuff about CARE CENTERs
• Attributes
• Name (ID)
• Location
• Cardinality with NURSEs
• One or more nurses assigned to it.
• One of them with an RN certificate has to be in
  charge.

9
Introduction

• Stuff about TECHNICIANs
• Assigned to one or more LABORATORY(ie)s
• Stuff about LABORATORY(ie)s
• Attributes
• Name (ID)
• Location
• Cardinality with TECHNICIANs
• LABORATORY has one or more TECHNICIANs

10
And finally

• Stuff about BEDs
• Cardinality with CARE CENTERs
• One or more BEDs in a CARE CENTER
• Attribute
• Bed_ID
• Bed
• Room
• Cardinality with RESIDENT
• Zero or one RESIDENTs in a BED (one would hope)

11
Everyone say HI, JASON!!

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

12
ltahemgt Project Questions

• Project Question 1s Answer
• Yep. The ability to model supertype/subtype
  relationships is likely to be very important for
  a hospital. A modern hospital is a triumph of
  specialization. Many hospital entities are
  likely to have subtypes. Por ejemplo
• ITEM Supply, Item, Prescription Item
• PATIENT Inpatient, Outpatient
• TEST Scan, Blood test
• PROCEDURE Biopsy, Surgical

13
Project Questions

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

14
Project Questions

• Project Question 2s Answer
• Yessir. Business rules allow a business to
  change its processes and procedures quickly in
  responding to environmental changes.

15
Project Questions

• 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 Questions

• Project Question 3s Answer
• You betcha. VISIT (scheduled for outpatients,
  cant exist with out em) is clearly one.

17
Project Questions

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

18
Project Questions

• Project Question 4s Answer
• A hospital has many business rules. For example
• Perhaps a patient cannot be admitted to the
  hospital without a referral from a responsible
  doctor
• Perhaps a nurse can be reassigned to a different
  care center only by permission of the nurse in
  charge of the care center where the nurse is
  assigned.

19
Project Exercises

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

20
Project Exercises
21
Project Exercises

• Project Exercise 2
• Develop definitions for each of the following
  types of objects in your EER diagram from Project
  Exercise 1. Make reasonable assumptions based on
  your (our) own knowledge and experience.
• Entity Types
• Attributes
• Relationships

22
Project Exercises

• Project Exercise 2s Answer
• a. Entity Types
• Physician A licensed medical doctor at MVCH
• Patient Someone who has ever been admitted to
  MVCH
• Employee A person who has a contract with and
  gets a check from MVCH
• Care Center A specialized treatment unit within
  the hospital

23
Project Exercises

• Project Exercise 2s Answer
• b. Attributes
• Person_ID Social Security Number
• Birth_Date Month, Day, and Year of birth
• Specialty A physicians area of expertise
• Location Building, wing, floor, room number.

24
Project Exercises

• Project Exercise 2s Answer
• c. Relationships
• Assigned Told to work, sleep, or otherwise
  exist somewhere or with someone.
• Scheduled Told to arrive at a time at least two
  hours before a doctor can actually see you.

25
Project Exercises

• 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 these
  questions
• a. Whats the anchor object? An entity, an
  attribute, a relationship, something else?
• b. Whats the corresponding object(s)?

26
Project Exercises

• Project Exercise 3s Answer
• Anchor object Nurse (entity)
• Corresponding object RN Certificate (attribute
  with specific value)

27
Project Exercises

• Project Exercise 4
• Compare the EER diagram you just developed with
  the E-R diagram a completely different team
  developed in Chapter 3, Project Exercise 2. What
  are the differences, and why are they there?

28
(No Transcript)
29
Project Exercises

• Project Exercise 4s Answer
• We identified more entities and their
  relationships this time.
• Now we have classes and subtypes on several
  levels. Basically, this ensures that all
  references to one person can be interrelated if
  the need arises.
• There are differences because the book chose to
  let us in on more information and new E-R
  notation in Chapter 4.

30
Project Exercises

• Project Exercise 5
• Merge those two diagrams into one. Explain the
  decisions made during merging.

31
(No Transcript)
32
Project Exercises

• Project Exercise 5 Answer
• Should there be a relationship among
  LABORATORY(ie)s, PATIENTs, and PHYSICIAN for
  tests?
• Do you attach ITEMs are consumed by to PATIENT,
  or one of its subclasses only?
• Do you keep the Patient is referred by Doctor
  for Treatment model, or the Doctor administers
  Treatment to Patient one?
• Used the latter, since it lends itself better to
  TREATMENT becoming an associative entity.

33
Lannys Much Simpler Question

• What phrase in the Project Description indicates
  that PERSON must be a supertype with multiple
  subtypes?

This question validates as Buzzword Compliant and
Dr. Segall lack-of-thinking compliant
34
Lannys Much Simpler Questions Answer

• Each of the four groups of persons has at least
  one unique attribute of its own. Until that is
  said, Person_Group could be an attribute of
  PERSON.

35
Jasons Question

• From the Project Description (pg. 160), identify
  an example of each listed type of action
  assertion (see pg. 152), if such examples exist.
• Condition
• Integrity Constraint
• Authorization

36
Jasons Questions Answer

• Condition If a nurse has an RN certificate,
  then she will be eligible to be appointed
  nurse_in_charge of a care center.
• Integrity Constraint A care center must always
  have a nurse_in_charge appointed to it.
• Authorization No authorizations exist in the
  description.

37
Brandons Question

• Identify an example of partial specialization and
  an example of total specialization from the
  project description (pg. 160).

38
Brandons Questions Answer

• Partial Specialization Some other persons in
  the hospital community do not belong to one of
  these four groups. However, a particular person
  may belong to two or more of these groups at a
  given time.
• Total Specialization Employees are subdivided
  into three groups nurse, staff, technician.