homework3.sql

*Central Hospital
*Eastern Hospital
*Northern Hospital

*Antonio Medico
*Sarah Soulcrusher

*Ibuprofen prescription (NDC: 67877-1191)

*Bacteria Identification Test lab procedure (LOINC 45335-7, property ACnc, timing Pt, system Isolate, scale type Ord, method type culture)  Patient Random Person

Scenario 1:
*No new test data

Scenario 2:
*Andy Programmer has allergy to aspirin first found Marth 14, 1999


Scenario 3:
*Baby Programmer had an office visit at North Hospital on [yesterday's date]
    *with previous note "Hates getting shots"
    *with lab procedure for specimen volumn
    *with immunizations for [measles,mumps,rebella], [hepatitis B], and [poliovirus]


Scenario 4:
*Andy Programmer had an office visit on 02/02/2011 at Central Hospital
    *with note including "Second medical visit on two days"
    *with prescription of 200mg Aspirin from 02/02/2011 to 02/09/2011 with instructions "Take once daily with a meal"


Scenario 5:
*Random Person had an office visit at Eastern Hospital on 01/26/2011
    *with note "Seems fine to me"
    *with diagnosis Tuberculosis of the Lung
    *with Injection procedure
    *with Bacteria identification test lab procedure
    *with Ibuprofen prescription for 01/26/2011 to 02/05/2011 with instructions "Take once daily"