1. Create a complete information package diagram for the information given in the ER diagram. 2. Create a star schema for the information showing all dimension tables, fact tables, attributes, and the relationships between the tables. Identify key attributes and relationship cardinalities, you may add new attributes for each dimension if necessary. 3. Suppose patient Omar Hassan was entered as Amer Hassan, and we want to update his data. What type of update is this? How would you update the patient dimension table? Show the new dimension table and its attributes. 4. Suppose that patient named Ahmad was transferred from a single-typed room to double-typed room due to another emergency which has required a single-typed room due to the critical status of patient named Zaid. How would you update the bed dimension table. Show the new dimension table and its attributes. 5. How many joins (based on the star schema) would be needed to answer the following query: What is the total number of patients who have Diabetes and treated by Dr.Salem? Explain briefly.