CIS 4365 Entity Relationship Diagrams Chapter3: Entity-Relationship Modeling:

CIS 4365 Entity Relationship Diagrams Chapter3: Entity-Relationship Modeling:

CIS 4365 Entity Relationship Diagrams Chapter3: Entity-Relationship Modeling: Part 2 1 CIS 4365 Entity Relationship Diagrams 2 Your Individual Project We will develop the ERD as a class; you must execute complete the project ON YOUR OWN We will go to the lab to create the tables I will give you the data to populate the tables I will help you get you get started with your queries PLEASE NOTE: When I say Individual, I mean you should do it by yourself You will NOT learn if your friend gives you the answers I WANT YOU TO LEARN! IF YOU WONT LEARN, YOU ARE WASTING YOUR MONEY! I still get paid (not much). I tried. CIS 4365 Entity Relationship Diagrams 3 Your Individual Project

Consider the following: You work for a hospital. The Head Administrator has told you that he suspects that Dr. Smith, as well as all of the other physicians which she supervises, has been pre-scribing too much Codeine for their patients. He wants a list of all of Dr. Smiths patients, their illnesses, and what drugs were given to those people. If it looks suspicious, he will later want the same list for each of the physicians Dr. Smith supervises. There is one additional constraint we will add: Each patient can have only one primary physician. CIS 4365 4 Entity Relationship Diagrams Your Individual Project Simplifying/Elucidating the Problem Semantics: A Physician Treats many Patients. A Patient is Treated by only one Primary Physician. Given Given Many Patients Suffer many Illnesses. Many Illnesses are Suffered by many Patients. Inferred Inferred Many Illnesses Require many Drugs Many Drugs are Required by many Illnesses. Inferred Inferred A Physician Supervises many other Physicians. A Physician is Supervised by another Physician. Inferred Inferred We can now identify (based in the original Statement) All of the

Entities and their Cardinality and, (implicitly), their constraints CIS 4365 5 Entity Relationship Diagrams Your Individual Project 1st Relationship: Physician Treats Given 1 Physician, how many Patients? Mandatory? Given 1 Patient, how many Physicians? Mandatory? Patient CIS 4365 6 Entity Relationship Diagrams Your Individual Project 1st Relationship: Attributes?? Physician Treats Patient Name Name Address Address

Specialty What is wrong with these attributes?? CIS 4365 7 Entity Relationship Diagrams Your Individual Project 1st Relationship: What if, in addition to looking for a physician (or patient) only by name, we look for them by name AND address?? Probably NOT a good idea (think: George Foreman) Solution: Assign a UNIQUE identifier: Physician Treats Patient PhysID Name Name PatID Address Address Specialty CIS 4365 8 Entity Relationship Diagrams Your Individual Project 1st Relationship:

How do we relate a Physician to their Patients? We could place the Patient Information (e.g., using the primary key PatID) as an attribute in the Physician Entity PhysID Physician Name Address Specialty PatIDa PatIDb PatID?? I think we have a problem!!! CIS 4365 9 Entity Relationship Diagrams Your Individual Project 1st Relationship: How do we relate a Physician to their Patients? Physician PhysID Name Address PatIDa PatIDb PatID??

Specialty Because this is a relational database, we need what is the maximum number of patients a patient can have: None? Maybe the physician has no patients presently admitted One? Maybe they are the Presidents Physician A Million? Maybe they are ambulance chasers Lets Assume the Maximum is 1,000. CIS 4365 10 Entity Relationship Diagrams Your Individual Project 1st Relationship: How do we relate a Physician to their Patients? Physician PhysID Name Address PatIDa PatIDb PatID?? Specialty If these our field sizes are: That means that we would need to increase the number of bytes needed FOR EACH RECORD to: 119+ 1,000 * 9 = 9,119 Bytes

If there are 300 physicians in the PHYSICIAN Table, the table will require 400 * 9,119 = 3,647,600 Bytes (The vast majority of Patient fields will be NULL) Field PhysID Name Address Specialty #Bytes 9 30 50 30 119 Plus 9 bytes per Patient Versus the 300 *119 = 35,700 bytes it would be otherwise CIS 4365 11 Entity Relationship Diagrams Your Individual Project 1st Relationship: How do we relate a Physician to their Patients? Note that we have seen this situation before: PhysID Patients Physician Name PatIDa Address Specialty

PhysID Other 123456789 234567890 345678901 456789010 PatID?? A Multivalued Attribute Repeating Groups PatID1 PatID2 PatID3 543210987 765432109 321098765 109876543 654321098 210987654 432109878 109876543 987654321 Not Good! PatID Other 987654321 109876543 765432109 654321098 543210987 432109876 321098765 210987654 432109878

CIS 5365 12 Entity Relationship Diagrams Your Individual Project 1st Relationship: How do we relate a Physician to their Patients? Lets try putting the foreign key in the Patient table Physician Treats Patient PhysID Name Name PatID Address Specialty Note that because this is a 1:M relationship, we only have to add 1 additional field to the Patient Table Address Physician CIS 5365 13 Entity Relationship Diagrams

Your Individual Project 1st Relationship: How do we relate a Physician to their Patients? Lets try putting the foreign key in the Patient table Notice the storage savings (Assume that table Patient, without the foreign key, require 100 bytes/record, & that there are 5,000 records) Foreign Key in PHYSICIAN Foreign Key in PATIENT PHYSICIAN PATIENT 3,647,600 Bytes 500,000 Bytes 35,700 Bytes 545,000 Bytes BOTH 4,147,600 Bytes 580,700 Bytes A savings of 3,566,900 Bytes How would the tables in this relationship look like? CIS 5365 Entity Relationship Diagrams 14 Your Individual Project 1st Relationship: How do we relate a Physician to their Patients? Physician Table Patient Table Attributes/Fields

Attributes/Fields PhysID 1 PatID Name Name Specialty Address Address M Physician Is the field Physician actually placed in the Patient Table??? YES See the next slide CIS 5365 15 Entity Relationship Diagrams Your Individual Project 1st Relationship: Physician Table PhysID 123456789 234567890 345678901 456789012 567890123 Patient Table

PatID 255356278 344244256 399872889 401293648 450192243 589021099 620896798 730927457 801928364 822981630 Our first rule is that in a 1:M relationship, the foreign key ALWAYS goes on the side of the many Physician 456789012 234567890 234567890 456789012 345678901 345678901 567890123 456789012 123456789 234567890 CIS 5365 16 Entity Relationship Diagrams Your Individual Project 1st Relationship: What do we do with the composite key ADDRESS? In this case, we simple decompose it into the fields we will use Physician Table Attributes/Fields

PhysID Patient Table Attributes/Fields 1 PatID Name Name Specialty Street Street City City State State ZipCode ZipCode M Physician CIS 5365 17 Entity Relationship Diagrams Your Individual Project 1st Relationship:

Our actual tables might appear as: PhyID 234567890 345678901 456789012 Last Kervorkian Zhivago Rebenneck First Jack Yuri Mac Street 32 Viscount 19 Redd Rd 65 Piano St. City El Paso El Paso La Union State TX TX NM Specialty Euthanasia Cardiology Orthopedics PatID 255356278 399872889 589021099 620896798

730927457 Last Sotomayor Bush Mubarack Martinez Lohan First Sonya W Hosni Susana Lindsay Street 12 Oregon 123 Mesa 18 Hideout 7 Mayor St 12 Necklace City El Paso El Paso El Paso Anthony El Paso State TX TX TX NM TX Physician 456789012 234567890 345678901 456789012 345678901

We Now Know: Sonya Sotomayor has Dr. Rebenneck as her physician W. Bush has Dr. Kervorkian as his physician Hosni Mubarark has Dr. Zhivago as his physician Susana Martinez has Dr. Rebenneck as her physician CIS 5365 18 Entity Relationship Diagrams Your Individual Project 2nd Relationship: Patient Suffers Illness Given 1 Patient, how many Illnesses? Mandatory? Given 1 Illness, how many Patients? Mandatory? Note that the true constraints of a problem are not always stated nor readily inferred --- CIS 5365 Entity Relationship Diagrams Your Individual Project 2nd Relationship: What about the attributes of Illness? Depends ---- lets keep it simple: Illness

IllCode Description 19 CIS 5365 20 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? Lets try putting the foreign key in table Patient PatID Patient Name Address Physician IllCodea IllCodeb IllCode?? OOPS!!! CIS 5365 21 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? The lets try putting the foreign key in table Illness IllCode

Illness Description PatIDa PatIDb PatID?? This is as bad as the other relationship !! CIS 5365 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? Were going to have to find a different solution. We will have create a separate table to link the two tables together. What Table?? How about a table called Suffers? But Suffers is a relationship, NOT a Table! Why cant it be both? 22 CIS 5365 23 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? Table SUFFERS will become an ASSOCIATIVE ENTITY Patient PatID

Name Address Physician Suffers But how will the tables be related?? Illness IllCode Descript. CIS 5365 24 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? We must use unique keys from each of the tables as foreign keys in Table SUFFERS Patient Suffers Illness PatID Name Address Physician IllCode PatID IllCode Descript. We can now With an

link a Patient Illness Doesnt every table also need a PRIMARY Key?? CIS 5365 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? We can use the two keys (PatID and IllCode) TOGETHER as the Primary Key Suffers This is known as concatenation PatID IllCode Notice that BOTH keys are primary keys AND foreign keys 25 CIS 5365 Entity Relationship Diagrams 26 Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? Concatenation is the operation of joining two character strings end-to-end. For example, suppose I have two strings: Then: A = How now And B = Brown Cow A + B = How now Brown Cow

So the two field are merged together into one field?? No. But the primary key considered as if they were. How does all this work?? CIS 5365 27 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? Assume that one record in table SUFFER appears as: Patient Suffers PatID Name 547286579 Clara Schuman PatID IllCode 547286579 A896507 Illness IllCode A896507 Description

Broken Left Ulna We know that Clara Schuman suffered a broken left ulna There is a problem here!!! CIS 5365 28 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? The problem is that the concatenated primary key is NOT unique What if, in the future, Clara again breaks her left Ulna: Patient Suffers PatID Name 547286579 Clara Schuman PatID IllCode 547286579 A896507 547286579 A896507 Illness IllCode A896507

Description Broken Left Ulna In both cases, the fields are: 547286579 A896507 A violation of Entity Integrity!!! CIS 5365 29 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? We could add a TIMESTAMP to the associative Entity: Suffers PatID IllCode DateSeen Notice that our concatenated primary key is now: PatID + IllCode + DateSeen CIS 5365 30 Entity Relationship Diagrams Your Individual Project 2nd Relationship: How do we relate a Patient to their Illnesses? Our tables would appear as: Suffers

PatID 547286579 547286579 IllCode DateSeen A896507 8/20/2009 A896507 2/16/2011 Illness Patient PatID Name 547286579 Clara Schuman IllCode A896507 Description Broken Left Ulna Note that even though Clara broke her arm again, the primary key is unique CIS 5365 31

Entity Relationship Diagrams Your Individual Project Our ERD so far: Physician PhysID Treats 1 .. * Patient PatID 1 .. * Suffers ~ PatID LastName LastName ~ IllCode FirstName FirstName DateSeen Street x Address City ~ Physician State Zipcode Specialty * .. 1

Illness IllCode Description Attribute Notation: Primary Key ~ Foreign Key x Composite Attribute Aside from using UML, what is different here???? Why is the relationship between Patient-Suffers-Illness 1..* - *..1?? CIS 5365 32 Entity Relationship Diagrams Your Individual Project As we have seen, we CAN NOT deal with M:M relationships: Initially we had: Patient PatID Suffers * .. * LastName Illness IllCode Description FirstName x Address ~ Physician We found out that we could not deal with this situation unless

we broke it into an Associative entity: Patient PatID 1 .. * Suffers ~ PatID x Name ~ IllCode x Address DateSeen ~ Physician * .. 1 Illness IllCode Description CIS 5365 33 Entity Relationship Diagrams Your Individual Project When we consider this relationship: Patient 1 .. * PatID Suffers ~ PatID x Name

~ IllCode x Address DateSeen * .. 1 Illness IllCode Description ~ Physician We should note that it is one we know how to deal with: In a 1:M relationship, the foreign key goes on the side of the many: Patient 1 M Suffers PatID ~ PatID x Name ~ IllCode x Address DateSeen ~ Physician PatID can occur only once in Patient, but many times in Suffers 1

M Illness IllCode Description IllCode can occur many times in Suffers, but only once in Illness CIS 5365 34 Entity Relationship Diagrams Your Individual Project The actual Tables might appear as: PatID 255356278 399872889 589021099 620896798 730927457 Last Sotomayor Bush Mubarack Martinez Lohan We Now Know: First Sonya W Hosni Susana Lindsay Street 12 Oregon

123 Mesa 18 Hideout 7 Mayor St 12 Necklace Sonya Sotomayor suffered from: A broken left foot on 2/29/2009 W Bush suffered from: Amnesia on 1/19/2009 Bad Hair on 4/19/2010 Hosni Mubarak suffered from: A Wounded Ego on 2/10/2011 Linsay Lohan suffered from: Sticky Fingers on 7/17/2010 Sticky Fingers (again) on 2/8/2011 Bad Hair on 10/23/2010 City El Paso El Paso El Paso Anthony El Paso State TX TX TX NM TX Physician 456789012 234567890 345678901 567890123 456789012 PatID IllCode DateSeen 399872889 C879013 1/18/2009 730927457 B348701

2/8/2011 589021099 D404678 2/10/2011 399872889 B667180 4/19/2010 730927457 B348701 7/17/2010 730927457 B667180 10/23/2010 255356278 A896507 9/29/2009 IllCode A507762 A896507 B348701 B667180 C879013 D404678 F750191 Description Broken Heart Broken Left Foot Sticky Fingers Bad Hair Amnesia Wounded Ego Headache CIS 5365 35 Entity Relationship Diagrams Your Individual Project 3rd Relationship: We already know how this one will come out Illness Requires Drugs

Given 1 Illness, how many Drugs? Mandatory? Given 1 Drug, how many Illnesses? Mandatory? We already know that this means that Requires will become an Associative Entity CIS 5365 Entity Relationship Diagrams Your Individual Project 3rd Relationship: The ERD can be rewritten as: Illness IllCode Description 1 .. * Requires IllCode * .. 1 Drugs Drugcode DrugCode Name DateGiven X Others Number Do we need DateGiven??? 36 CIS 5365

37 Entity Relationship Diagrams Your Individual Project 3rd Relationship: I think we have a problem!!! Lets look at the tables we might generate: Requires Illness IllCode A507762 A896507 B348701 C879013 F750191 Description Broken Heart Broken Left Foot Sticky Fingers Amnesia Bad Hair IllCode B348701 C879013 F750191 B348701 B348701 A507762 B348701 A896507 DrugCod e DateGiven No 27891101 8/19/2009 23 10334567 12/16/2009 90

53372820 2/23/2010 60 10334567 4/13/2010 20 53372820 10/20/2009 60 72234695 3/14/2011 150 10334567 12/23/2010 30 33890112 1/27/2010 45 Drugs DrugCode 10334567 12337690 27891101 27781018 33890112 45399034 53372820 72234695 Name Thorazine Aspirin Placebo Retin-A Codeine Ibuprofin Laughing Gas Vitamin A All we know is: A Broken Heart has been treated with Vitamin A A Broken Left Foot has been treated with Codeine Sticky Fingers has been treated with Thorazine, Retin-A, Laughing Gas & Codeine Bad Hair has been treated with a Placebo SO??? CIS 5365 38 Entity Relationship Diagrams Your Individual Project 3rd Relationship:

Lets consider our old friend Lindsay Lohan Patient PatID Last 730927457 Lohan DateSeen 2/8/2011 7/17/2010 10/23/2010 Require IllCode B348701 B348701 B348701 F750191 State Physician TX 345678901 Illness Suffers PatID IllCode 730927457 B348701 730927457 B348701 730927457 F750191 First Street City Lindsay 12 Necklace El Paso DrugCode DateGiven 27891101 8/19/2009 53372820 10/20/2009 33890112 12/23/2010

27891101 6/19/2010 IllCode Description B348701 Sticky Fingers F750191 Bad Hair Drugs DrugCode 10334567 27891101 33890112 53372820 72234695 Name Thorazine Placebo Codeine Laughing Gas Vitamin A We know Lindsay suffers from Sticky Fingers, and that sticky fingers have been treated using Thorazine, Codeine, Laughing Gas, and Vitamin A Which ones were given to Lindsay??? CIS 5365 39 Entity Relationship Diagrams Your Individual Project 4th Relationship: We could try and create a relationship between patient and drug Patient Suffers Given one Drug, how many Patients? Mandatory?

Illness Require Given one Patient, how many Drugs? Mandatory? Is Given Drugs CIS 5365 40 Entity Relationship Diagrams Your Individual Project 4th Relationship: The tables might appear as: Patient 1 .. * PatID Suffers ~ PatID x Name ~ IllCode x Address DateSeen Illness * .. 1 IllCode Description

Requires ~ Physician 1 1 * IllCode Seems Messy!! DrugCode 5 Tables 5 Relationships PatId and IllCode each used in 3 different Tables DateGiven Number All to link a Patient with an Illness and a Drug??? Drugs Drugcode Name * ~ PatID * 1 CIS 5365 Entity Relationship Diagrams 41 Your Individual Project Lets think this through

Can we have a patient who doesnt have an illness? Can we have a patient who need any drugs? Can there be an illness that is not associated with any Patient? Can there be a illness that is not associated with any Drug? Can there be a Drug that is not associated with any Patient? Can there be a Drug that is not associated with any Illness? The three entities are Interrelated CIS 5365 42 Entity Relationship Diagrams Your Individual Project Developing a Ternary relationship We know the three entities involved: Lets call the relationship between them Treatment Patient Illness Treatment Given 1 Patient and 1 Illness, how many Drugs? Given 1 Patient and 1 Drug, how many Illnesses? Given 1 Illness and 1 Drug, how many Patients? A M:M:M ternary relationship Drug Many Many Many CIS 5365 43

Entity Relationship Diagrams Your Individual Project Developing a Ternary relationship Lets look at some of the attributes required: Patient PatID x Name Houston, we have a problem!!! x Address ~ Physician * 1 Treatment Illness * .. 1 IllCode Description ~ PatID ~ IllCode ~ DrugCode Drugs * .. 1 Drugcode Name ~ PatID Note that these have NOT changed CIS 5365 Entity Relationship Diagrams 44 Your Individual Project

Developing a Ternary relationship Just as we did in the Associative Entity Suffers, We could add a Time Stamp (to make the primary key unique): Treatment Treatment ~ PatID TreatID ~ IllCode ~ PatID ~ DrugCode ~ IllCode TDate ~ DrugCode TDate Instead of 4-concatenated keys, could we add a single autonumbered Key? Yes - Having a single primary is always nice BUT - We still have to make sure that a patient treatment is NOT entered twice CIS 5365 45 Entity Relationship Diagrams Your Individual Project Developing a Ternary relationship Lets see how the Tables might appear: Patient PatID 255356278

399872889 589021099 620896798 730927457 Last Sotomayor Bush Mubarack Martinez Lohan Illness IllCode A507762 A896507 B348701 B667180 C879013 D102234 F750191 Description Broken Heart Broken Left Foot Sticky Fingers Bad Hair Amnesia Wounded Ego Headache First Sonya W Hosni Susana Lindsay Street 12 Oregon 123 Mesa 18 Hideout 7 Mayor St 12 Necklace

City El Paso El Paso El Paso Anthony El Paso State TX TX TX NM TX Physician 456789012 234567890 345678901 456789012 345678901 Treatment PatID 399872889 730927457 730927457 399872889 255356278 620896798 255356278 730927457 589021099 589021099 IllCode C879013 B348701 B667180 B667180 A507762 F750191 F750191 B348701

D102234 F750191 DrugCode 53372820 72234695 27781018 27891101 10334567 12337690 27891101 33890112 53372820 10334567 Drugs TDate 1/19/2009 6/20/2009 4/15/2010 5/1/2010 6/10/2010 7/16/2010 12/6/2010 2/8/2010 2/10/2011 2/10/2011 How would this work? DrugCode 10334567 12337690 27891101 27781018 33890112 45399034 53372820 72234695 Name Thorazine Aspirin Placebo

Retin-A Codeine Ibuprofin Laughing Gas Vitamin A CIS 5365 46 Entity Relationship Diagrams Your Individual Project Developing a Ternary relationship Lets pick on poor Lindsay any more; Lets pick on poor W. Patient PatID 399872889 Illness IllCode Description B667180 Bad Hair C879013 Amnesia Last Bush First W Street 123 Mesa City State Physician El Paso TX 234567890 Treatment PatID IllCode 399872889 C879013 399872889 B667180

DrugCode 53372820 27891101 Drugs TDate 1/19/2009 5/1/2010 DrugCode Name 27891101 Placebo 53372820 Laughing Gas On January 19, 2009 W. suffered Amnesia and was given Laughing Gas On May 1, 2010 suffered Bad Hair and was given a Placebo Is this an improvement over our previous model?? CIS 5365 47 Entity Relationship Diagrams Your Individual Project Developing a Ternary relationship We know that we eliminated two relationships (Suffers and Requires) and replaced them with one (Treatment). Lets look at the size of the old model: Patient Field: PatID Last First Street Size (Bytes): 9 15 10 25 Illness Field: Size (Bytes):

IllCode 8 City State Physician 20 2 9 Description 25 Total: 90 bytes Total: 33 bytes Drugs Field: DrugCode Name Size (Bytes): 9 25 The size of these tables remain unchanged. Total: 34 bytes 157 bytes Suffers Field: PatID IllCode DateSeen Size (Bytes): 9 8 10 Total: 27 bytes Requires Field: IllCode DrugCode DateGiven Size (Bytes): 8 9 10

Total: 27 bytes 54 bytes CIS 5365 48 Entity Relationship Diagrams Your Individual Project Developing a Ternary relationship Lets look at the size of the New model: We know that Tables Patient, Illness, and Drugs will remain unchanged. The only change will be in the size of the Associative Entities 54 bytes Size of Old Model Associative Entities: Size of New Model Associative Entity: Field: PatID IllCode DrugCode TDate Size (Bytes): 9 8 9 10 36 bytes A savings of only 18 bytes per record, But: A saving of one Table A Substantial saving in Metadata A large savings if we have a large number of records: If we have 100,000 records, we save 1,800,000 Bytes Occams Razor: "entities must not be multiplied beyond necessity" CIS 5365 Entity Relationship Diagrams 49 Your Individual Project

We have only one more relationship left: You work for a hospital. The Head Administrator has told you that he suspects that Dr. Smith, as well as all of the other physicians which she supervises, has been pre-scribing too much Codeine for their patients. We have seen this type of relationship before: Physician Supervises CIS 5365 50 Entity Relationship Diagrams Your Individual Project We have only one more relationship left: Lets see how the Table might appear: Physician PhysID LastName FirstName Street City State Zipcode Specialty ~ Supervisor PhyID 234567890 345678901 456789012 567890123 678901234 Last Kervorkian Zhivago Rebenneck Love McGraw

First Street Jack 32 Viscount Yuri 19 Redd Rd Mac 65 Piano St. Strange 7 Rio St, Phil 12 S.R. 123 City El Paso El Paso La Union El Paso Canutio Dr. Jack Kervorkian Supervises Dr. Strange Love Dr. Phil McGraw Dr. Mac Rebenneck Supervises Dr. Yuri Zhivago St TX TX NM TX NM Specialty Euthanasia Cardiology Orthopedics Psychiatry Oprahology Super. 456789012 234567890 234567890

CIS 5365 51 Entity Relationship Diagrams Your Individual Project We have only one more relationship left: Lets see how the Table might appear: Physician PhysID LastName FirstName Street City State Zipcode Specialty ~ Supervisor PhyID 234567890 345678901 456789012 567890123 678901234 Last Kervorkian Zhivago Rebenneck Love McGraw First Street Jack 32 Viscount Yuri 19 Redd Rd Mac 65 Piano St. Strange 7 Rio St,

Phil 12 S.R. 123 City El Paso El Paso La Union El Paso Canutio Dr. Jack Kervorkian Supervises Dr. Strange Love Dr. Phil McGraw Dr. Mac Rebenneck Supervises Dr. Yuri Zhivago St TX TX NM TX NM Specialty Euthanasia Cardiology Orthopedics Psychiatry Oprahology Super. 456789012 234567890 234567890 CIS 5365 52 Entity Relationship Diagrams Our Final ERD Supervises

Physician Treats Patient Illness Treatment Drugs CIS 5365 53 Entity Relationship Diagrams Our Final ERD (Using UML) Patient Physician 1 PhysID PatID LastName x Name FirstName x Address Street ~ Physician 1 City State

Zipcode Illness Specialty IllCode * ~ Supervisor Description Treatment 1 ~ PatID * ~ IllCode ~ DrugCode * TDate Drugs * 1 Drugcode Name ~ PatID CIS 5365 Entity Relationship Diagrams Any Questions?? 54

Recently Viewed Presentations

  • Tercera semana del desarrollo embrionario

    Tercera semana del desarrollo embrionario

    Gastrulación: formación de las capas germinativas. Proceso de transformación del disco bilaminar a trilaminar. Representa el inicio de la morfogénesis y es el fenómeno más importante que ocurre durante la tercera semana, en esta etapa se le denomina al embrión...
  • Success on the AP Psychology Exam  Knowledge  Need

    Success on the AP Psychology Exam Knowledge Need

    Give an example of how each of the following could affect their performance. Definitions without application do not score. ... Classical conditioning and operant conditioning are different learning methods. ... apply each of the following in an argument against the...
  • Preventing Occupational Lead Exposure Safety Measures to Take

    Preventing Occupational Lead Exposure Safety Measures to Take

    Swartz, Matthew A. "Occupational Lead Exposure: Health Effects and Remediation Practices." Professional Safety 46 (2001): 28. "Wiping Out Lead at Work." Environmental Health Perspectives 111 (2003): 1-1. Cassidy Kist Science and Society Lead and Humanity Professor Alanah Fitch
  • Kwanzaa - Kindergarten Christmas Around the World!

    Kwanzaa - Kindergarten Christmas Around the World!

    The word Kwanzaa means "first fruits" in Swahili. What does the word Kwanzaa mean? Dr. Maulana Karenga created Kwanzaa in December 1966. Who started Kwanzaa? Kwanzaa is celebrated from December 26th to January 1st each year. When is Kwanzaa celebrated?...
  • Philosophy 190: Seminar on Kant Spring, 2015 Prof.

    Philosophy 190: Seminar on Kant Spring, 2015 Prof.

    Immanuel Kant Some Information about Primary Texts Italics are used when Kant employed Latin terms. Bold face is used for terms that Kant's original 1781/1787 editions put in Boldface 'Fraktur,' the German font of Kant's day. So last word in...
  • UI/UX Design Samples

    UI/UX Design Samples

    Use Iterative development. It should encompass the principles of HCI. Human-Computer Interaction (HCI) A field of study concerned with the efficiency and effectiveness of user interaction with computer systems, human-oriented input and output technology, and psychological aspects of user interfaces....
  • Update Cardiac Chest Pain Pathways at NUH Dr

    Update Cardiac Chest Pain Pathways at NUH Dr

    Improves primary prevention Guidance -who and when to refer Choose and Book referral Electronic desktop guidance CPS service replaces RACPC Pts investigation and plan within 4/52 May be scope for rapid speciality assessment service in future for pts with pain...
  • AQA POWER AND CONFLICT POETRY MY LAST DUCHESS

    AQA POWER AND CONFLICT POETRY MY LAST DUCHESS

    The poem is set in 1564, three years after the death of the Duchess. An emissary (messenger or representative) has been sent to see the Duke from the Count of Tyrol. The Count is the father of the Duke's next...