ISEN $2616$ System Analysis and Design Homework Assignment #$1(100$ pts$)$ Submit by $1/26/2024()$ Consider the following set of requirements for a healthcare system. Nittany Tiger Hospital is planning to build an information system. One of the major tasks of the project is to create a database system for the hospital $.$ The hospital consists of multiple departments such as pediatrics and orthopedics $.$ Each department has a unique ID name $,$ phone number and multiple locations $.$ A particular doctor manages a department $.$ Doctors nurses and staff are employees of the hospital $.$ An employee works for only one department $,$ and all employees belong to a department $.$ The organizational structure of the hospital is strictly hierarchical $,$ so among the employees $,$ a particular employee supervises other employees $.$ The database system stores employee's name $,$ social security number $,$ job type $($ doctor $,$ nurse or staff $),$ salary $,$ an address $,$ office phone number $,$ cell phone number gender $,$ age and birth date $.$ The system stores patient's name $,$ patient ID social security number $,$ gender $,$ birth date $,$ blood type $($ABO system $),$ and a home address $.$ Each patient makes an appointment with a doctor or a nurse with a scheduled appointment time $.$ Operations are performed by doctors $.$ Multiple doctors and nurses work on each operation $.$ Each operation has a unique operation ID$,$ name $,$ time and location $.$ Of course $,$ a doctor can perform multiple operations $,$ and a patient can undergo multiple operations $.$ For emergency patient's acquaintance information $($name $,$ relationship $,$ and phone number $)$ is stored in the system $.$ Storing multiple acquaintances is recommended $.($ IDs are assumed to be unique $.)$ Answer the following questions clearly and precisely $.1\mathrm{.}1.$ Identify and list all the entity types $,$ relationship types $,$ and corresponding attributes $.1\mathrm{.}2.$ List and describe the degree with respect to each relationship type $.1\mathrm{.}3.$ List and explain all the structural constraints of all the relationship types $2.$ Draw the ER $-$ diagram for the scenario above $.$