Draw an entity-relationship diagram for the following:
The entities you are going to deal with are: doctor, patient, medicine, and prescriptions
The relationships are:
- A
doctor can treat many patients and a patient can have many doctors.
- A
doctor can prescribe many drugs to a patient.
- Patients
must fill prescriptions.
- Prescriptions
are for medicines.