USing SQL and corresponding to the table below; give the statements to perform the following:

1. When deleting a record of an employee who is a manager, the managerID field of the department she/he works for should be set to null.

2. When deleting a record of a department, the deptName field of all employees who work in that department should be set to null.

Please respond, cannot find help anywhere.

Departments Name managerlD RD SALES Employees ID 123 Name John Robert Jenny Christ Bill Susan Salary 56000 37500 46000 39000 50000 67500 deptName RD HR HR SALES RD RD ?? 101