1. Given the following requirements of a hospital system, Each employee has a unique employee id (e_id), a name, multiple phones, and salary. Some, but not all, employees are categorized as doctor, nurse, or staff (exclusively) Each and every doctor is categorized as attending, resident, or intern (exclusively) . There are several medical teams. Each team has a unique team id (t_id) and a unique name, and consists of at least one attending doctor, one or more residents, and 0 or more interns. Each team is lead by one attending doctor Each attending doctor may lead up to 2 teams, may be a member of some teams, and may be the primary doctor for some patients. Each resident and each intern may be a member of some teams. Each patient has a unique patient id (p_id) and a name, resides in one room in the hospital, and has one primary attending doctor Each room has a unique room id (r_id), a type (single, double, etc), a max capacity, the current number of A nurse may supervise 0 or more nurses, may be supervised by a supervising nurse, and may staff 0 or more A patient may receive some treatments, each with a treatment id (tid). t_id is unique for a given patient only, patients assigned to the room (derived from patients assigned to the room), and is staffed by one nurse. rooms and may have duplicated values for different patients. A treatment may be provided by some teams. A team may offer some treatments. a. Draw the EER diagram (Peter Chen's notation) without using the (min, max) notation. Specify entities, weak entities, attributes, multi-valued attributes, keys (underline), partial keys (dashed underline), relationships (identifying or not, including name, type, participation, cardinality ratio), parent/child classes with overlapping/disjoint specialization, eto 1. Given the following requirements of a hospital system, Each employee has a unique employee id (e_id), a name, multiple phones, and salary. Some, but not all, employees are categorized as doctor, nurse, or staff (exclusively) Each and every doctor is categorized as attending, resident, or intern (exclusively) . There are several medical teams. Each team has a unique team id (t_id) and a unique name, and consists of at least one attending doctor, one or more residents, and 0 or more interns. Each team is lead by one attending doctor Each attending doctor may lead up to 2 teams, may be a member of some teams, and may be the primary doctor for some patients. Each resident and each intern may be a member of some teams. Each patient has a unique patient id (p_id) and a name, resides in one room in the hospital, and has one primary attending doctor Each room has a unique room id (r_id), a type (single, double, etc), a max capacity, the current number of A nurse may supervise 0 or more nurses, may be supervised by a supervising nurse, and may staff 0 or more A patient may receive some treatments, each with a treatment id (tid). t_id is unique for a given patient only, patients assigned to the room (derived from patients assigned to the room), and is staffed by one nurse. rooms and may have duplicated values for different patients. A treatment may be provided by some teams. A team may offer some treatments. a. Draw the EER diagram (Peter Chen's notation) without using the (min, max) notation. Specify entities, weak entities, attributes, multi-valued attributes, keys (underline), partial keys (dashed underline), relationships (identifying or not, including name, type, participation, cardinality ratio), parent/child classes with overlapping/disjoint specialization, eto