Transforming an E-R Model

• Cases 1-3: M:N

PATIENT (PATIENT_ID, PATIENT_LNAME, PATIENT_PHYSICIAN,...)

DRUG (DRUG_ID, DRUG_NAME, DRUG_MANUFACTURER, ...)

PRESCRIBE(PATIENT_ID, DRUG_ID, DOSAGE, DATE…)

PATIENT

DRUG

prescribed

M

N

NOTE: The relationship may have its own attributes.

1

1

Previous slide

Next slide

Back to first slide

View graphic version