Addendum to CPS 430/542 Homework #2

Assigned: September 6
Due: September 13, 4:30pm, in class

  1. (10 points) Provide an E/R diagram which models the following situation: Doctors prescribe drugs for patients. A given doctor can prescribe many drugs for a certain patient. Many doctors can treat a patient. Many doctors can prescribe the same drug to the same patient. A prescription can involve more than one patient (e.g., a mother and her baby), more than one drug, but is associated with a unique doctor.

  2. (10 points) Exercise 4.3.3 on p. 155 from [FCDB].

Return Home