Legend provides details for each decision point

Info icon This preview shows pages 11–23. Sign up to view the full content.

Legend provides details for each decision point Listing the specific conditional statement Must be present Connectors/links are decisions Labeled with choice statement Ovals/leaves are actions End result of traversing that path Labeled with resultant activity
Image of page 11

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

12 1 2 1.) Is the patient covered by one of our doctors? 2.) Is the patient on their doctor’s watch list? Yes Yes No Page Dr. End call Make new appt. No Problem: Scalability (severe)
Image of page 12
Decision Tables Structured decision matrix Excellent at representing complexity Help to ensure completeness, expose gaps Very good scalability
Image of page 13

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Decision Tables Decision tables consist of Condition stubs – what’s the situation? Action stubs – what’s to be done? Rules under what condition do you perform an action?
Image of page 14
15 1 2 3 4 Valid patient Y N Y N On watch list Y Y N N End call X X Page Dr. X New appt. X Conditions Actions Rules Problem: Readability, impact of actions
Image of page 15

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Decision Tables First, create with all possibilities Permute conditions to expose all potential rules Just as you would for truth tables Second, reduce table Mechanically combine condition/rule pairs that are redundant, even if not obviously so… Focus on common action sets
Image of page 16
17 1 2 3 4 Valid patient Y N Y N On watch list Y Y N N End call X X Page Dr. X New appt. X Conditions Actions Rules
Image of page 17

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

18 1 2 3 4 Valid patient Y N Y N On watch list Y Y N N End call X X Page Dr. X New appt. X Reduction
Image of page 18
19 1 2 3 Valid patient Y N Y On watch list Y - * N End call X Page Dr. X New appt. X Reduction * When a decision is no longer logically relevant due to a table reduction, there are different approaches to its representation. Most common are to remain within the existing symbol set and select the most appropriate symbol or to have a specialized symbol to represent this (such as a dash).
Image of page 19

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Conversion Structured English, Decision Trees and Decision Tables are all data equivalent (represent identical information) Can convert between them (CASE tool bonus) In either representation decisions do not have to be binary categories (e.g., Y/N or T/F), could be other discreet label or range (e.g., S/M/L/XL or 1..5)
Image of page 20
21 1 2 3 4 Valid patient Y N Y N On watch list Y Y N N End call X X Page Dr. X Make new appt X Conditions Actions Rules 1 2 1.) Is the patient covered by one of our doctors? 2.) Is the patient on their doctor’s watch list? Yes Yes No Page Dr. End call Make new appt. No
Image of page 21

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Class Exercise Niki’s Tandoori Express is an Indian “fast food” restaurant. “Combo meals” are popular which include basmati rice and two sides depending on the entrée… If you order a vegetarian entrée, it will come with garlic naan. If you order a meat entrée, it will come with regular naan. If the entrée is spicy, it will be accompanied by raita.
Image of page 22
Image of page 23
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '08
  • Koru,G
  • Entity-relationship model

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern