A database is needed for a hospital, where we need to keep records of Patients, Doctors, Receptionists, Departments, Medicines, Tests, Rooms, Nurses, and Bills. The data requirements are summarized as follows:

There are many departments in the hospital. A unique name, a unique number, a location, many phone numbers, and a department manager characterize each department.

Employees working in the hospital must be assigned in one of the different departments. An employee is identified by the unique job_ID, the name of the employee (composed of a first name, a middle name, and a the last name), many addresses and phone numbers, a date of birth and a Salary. Employees can be doctors, nurses, technicians, and receptionist.

Doctors are distinguished by their specialty, an office number, and an office phone number. A doctor is managing one and only one department. We need to keep track of the date when the manager joined the department. A Doctor can also prescribe a medicine to a patient. The Medicine is known by a unique medicine code, a name, a manufacturing company, a manufacturing date, an expiry date, and a price.

A receptionist is distinguished by having a number of languages he/she can speak, and having many computer skills. A Receptionist can admit an InPatient in one Room in a certain date and time.

A Room is describe by its unique room number, floor number, a room type, and a room cost.

For nurses, we record their years of experience, previous hospital they worked for, and their work shifts. One or many nurses can give nursing services to one patient in a specific room. We need to keep track on the type of service given to the patient and the date it has been given.

A patient is described by its unique patient number, a first name, a last name, a phone number, an address (that includes the street name, the street number, the apartment number, and the zone number), the date of birth, and the gender identify a patient. We need to have the age of the patient. An OutPatient can take an appointment with a doctor, and which will be placed by a receptionist and is given a unique appointment number, a date and time.

Each patient needs to pay one or many bills. A bill is described as having a pill ID, a bill amount, and a bill purpose. For each payment, we need to keep record of the payment id, the payment method, and the time and date of payment.

Design an EER diagram for the hospital database.