Question 3 SQL queries (10 marks) Consider the following relational schema and briefly answer the questions that follow: Emp (eid: integer, ename: string, age: integer, salary: real) Works (eid: integer, did: integer, pct_time: integer) Dept (did: integer, budget: real, managerid: integer)

b. Write SQL statements to delete all information about managers whose salaries are more than twice of the average salary of the employees in the department. Be sure to ensure that all the relevant integrity constraints are satisfied after your updates.