(a) The hospital keeps track of each doctor's name, doctor ID, social security number, birthdate, language, specialties and position. Both social security number and doctor ID have unique values for each doctor. One doctor must belong to one department. One department must be managed by one doctor. (b) Each department is described by a name, department ID, department category, department phone, and established date. Both name and department id have unique values for each department (e) Each Diagnosis Time has a start date time, and capacity One diagnosistime belongs to one doctor and each doctor can have several diagnosis time (d) Each patient has patient ID, name, sex, birthday, address, and social security number. Some hospital records need to refer to the city, state, and zip of the patient's address, and to the patient's last name. Both patient number and social security number have unique values for each patient. Patient can choose one diagnosis time of one doctor to register for an appointment. Once the appointment was made, patient will get one registration number and the estimated time. (e) Each nurse has nurse ID, name, social security number, nursing credential and nursing certification. Both nurse ID and social security number have unique values for each nurse. Each nurse must belong to one department and take care of one or more patients Design an ER schema for this application, and draw an ER diagram for that schema. Specify key attributes of each entity type and structural constraints on each relationship type using (min, max) notation. Note any unspecified requirements, and make