Using the Washington County Judicial Case sample ER model solution below to create a logical model by

transforming each entity, attribute, and relationship. Additional details regarding the case can be found in

Assignment $1$ and the Assignment $1$ sample solution posted on Blackboard.

MEDICINE

medicinelD

medicine name

manufacturer

AGENCY INTERACTION

agencyinteractionID

contact date

employment status at interaction

address at interaction $($address$1,$

address$2,$ city, state, zip$)$

reason for interaction

$-$H$--$is associated with$-$

PRESCRIPTION

prescriptionID

dosage

is associated with

DIAGNOSIS

diagnosisID

date of diagnosis

notes

is performed by a

employment information $($start

date, end date$)$

job title

is associated with

AGENCY

agencylD

agency type

agency name