Reference no: EM132919174

Draw ER diagram base on the scenario:

1. Each prescription (identified by prescription ID) is associated with one patient and each patient (identified by Patient ID) has many prescriptions.

2. Each doctor (IDed by doctor ID) may be associated with many prescriptions and each prescription is by one doctor.

3. Each prescrition may contain many drugs and each drug (IDed by drug ID) is associated with many prescritions.

For each patient we also want to know her first name, last name, street address, city, state, and ZIP.

For each doctor, we also want to know his first name, last name, street address, city, state, and ZIP.

For each prescription, we also want to know its date (data type: date time).

For each drug, we also want to know its name and dose (a float number)