~\"'---"- '1\"""""'\" \"- ' -~'-C-\"-"\"' "' l' 4. A multi-specialty medical center has several physicians. Each physician has one specialty. The administration of this medical center needs to keep track of the information about each physician such as a physician's ID, name, specialty, salary, cell phone, etc. The administration also needs to keep track of the information of all patients of this medical center, including patient's ID, rst_name, 1ast_name, date of birth, gender, name of insurance, insurance policy number, telephone, billing address, etc. The administration needs to know which physician takes care of which patients. Assuming each physician takes care of many patients; and a patient may see several physicians with different specialty. Patient must make an appointment to see a doctor. At each appointment when a doctor sees a patient, doctor needs to write a note for this patient which records the date and time he/she sees the patient, purpose of this patient's visit, the treatment or prescriptions or suggestions made for the patient, etc. Some doctors are also involved in one or more research projects with the collaboration of a local medical school. The administration of the medical center needs to know which doctors involved the research project(s), projects' titles, starting time and ending time of each project, and the director of each project. The administration also needs to keep track of doctors\" on-call schedules. Depending on the date, doctors' on- call hours may be different. When a patient is hospitalized, the administration needs to know the name of hospital, reasons of admission, period of admission, attending doctor, etc 41. Create an ER model based on above information 42 Transform the ER model into a set of tables (following the \"Rules of converting an ER model into table design' posted at Canvas) Part B (Normalization) Note: when you are asked to analyze a given table, you should go through the following steps (in some cases, information regarding these steps are given): I. make the table in the format: table_name {attribute}, attribute2, ...). 2. List allfunctional dependencies (FDs). And list all maltivalued dependencies, if there is any. 3. dene the key (and candidate key if there is any) for this table. Also, underline the key. 4. state the highest level of normal form this table is currently in. Give a clear explanation and use related normal form denition to justify your answer. 5. ifthis table is not in 3NF or BCNE then normalize it by decomposing the table into a set of tables that are in SNF or BCNF Don 't forget to underline the key and indicate FK if there is any