05-08-2012, 11:02 PM
Make an E-R diagram for Ambulance services providing company. The database contains data about the driver, emergency incidents/ accidents involving the pickup, vehicles and patients (who get picked up). One doctor and one staff nurse with technician will be in the ambulance. The drivers may be involved in different pickups at different times. The technicians may be involved in different pickups in different times. The doctor and the nurse at a maximum can be involved in 4 pickups a day. Only one patient will be involved in one picup. Make necessary assumptions