Reflect in the database a situation when an employee is assigned to a new Care Center with X hours per week, and his work hours in another Care Center where he was previously assigned are decreased by X hours (to preserve his total weekly number of hours). 1. 2. Reflect in t the Patient and need to change the admitting Physician. he database a situation when you noticed a mistake about the Physician who admitted 3. Selec hames of patients wh wen admited had temperture higher than x and blood pressure higher than Y 4. Select IDs of Patients and the number of times they consumed the ltem x. 5. Select IDs of Patients and the number of times they consumed the Item X for the Patients who consumed this item more than Y times. Select the name of patient, the bed number he/she is assigned to and the name of the Care Cen where the bed is. 6. Select IDs and Names of Employees who have more hours per week in any Care Center they w than the average weekly number of hours. 7. Reflect in the database a situation when an employee is assigned to a new Care Center with X hours per week, and his work hours in another Care Center where he was previously assigned are decreased by X hours (to preserve his total weekly number of hours). 1. 2. Reflect in t the Patient and need to change the admitting Physician. he database a situation when you noticed a mistake about the Physician who admitted 3. Selec hames of patients wh wen admited had temperture higher than x and blood pressure higher than Y 4. Select IDs of Patients and the number of times they consumed the ltem x. 5. Select IDs of Patients and the number of times they consumed the Item X for the Patients who consumed this item more than Y times. Select the name of patient, the bed number he/she is assigned to and the name of the Care Cen where the bed is. 6. Select IDs and Names of Employees who have more hours per week in any Care Center they w than the average weekly number of hours. 7