Q 1.Design an entity-relationship diagram for the following scenario: Hospitals with (hospital number, number of beds, name, and address) employ doctors (name, social security number, address, and subject area), each

doctor treats several patients (name, gender,address, date of birth and patient number), and also a patient may be treated by several doctors. Each nurse (name, address, department, age, and social security number) is responsible for several rooms(room number and number of beds), and several patients may occupy one room.