the two question please

Consider the following information system for a hospital. The Inpatient section in the hospital consists of several departments and labs as follows. Each Department is described by a Department number (unique), Department Name, a set of doctors and a set of beds. Each Department has a head. Each Doctor is described by a Doc_Id (unique), Doctor Name, Status (internal or external), and Specialization, and is allowed to work in only one Department. Each Bed is described by Bed Number (unique for each department), Bed Category (1st, 2nd, 3rd class). Each Bed Category has a different Price. Each lab is described by Lab number (Unique), Lab Name, Lab Manager) and a set of services. Each Service is described by Service No (Unique), Service Name, and Service Fees. Each Patient is Described by Patient Number (Unique), Patient Name, Patient Address, and Patient Phone Number. Each Patient is assigned a bed, and is supervised by only one Doctor. It is required to keep track of the prescriptions assigned by each doctor to each patient. Finally, It is required to record the lab services requested by each doctor for each patient. or the aforementioned information system. (assume any missing attributes): Z th Week Exam: Assignment \#1 (15 marks): Draw the corresponding enhanced ER diagram including the completeness constraint, the disjointness constraint, and all subtype discriminators. Z th Week Exam: Assignment \#2 (15 marks): Draw the corresponding relational data model (RDM). Then, write the SQL statements needed to create all tables