Assignment 2 - Use ER diagram to design a relational DB

** taken from the very last slide (68) of lecture one ** Construct an E-R diagram to represent the following context within a hospital with several departments:

  • A department has several laboratories, each identified by a number.
  • Each lab has several machines and each machine 3 operators, who take turns over the course of 24 hours.
  • One operator can work on more than one machine.
  • Each operator must be on call at one phone number at all times.
  • Different machines perform different examinations.
  • You want to be able to report the number of examinations performed each day.