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.