1. [15 points] A hospital database needs to store information about doctors (identified by doctor_id, with name and specialization as attributes), patients (identified by patient_id, with name, date-admitted, date-checked-out and symptom as attributes), diagnosis (identified by code, with date, time and result as attributes). A patient was diagnosed by one or more doctors about his symptoms. A doctor was known to make diagnoses by evaluation of the patient's chief complaint and symptoms. Each diagnosis can only be made by a doctor. A patient owns diagnoses which have important results for patient care, research, and policy. The diagnoses can only exist for a patient. Draw an ER diagram for this hospital database. Note that you should identify the primary key attributes on the diagram