its database subject

Task 3. [30 points) Write triggers for the following general constraints. 1. When a new manager is appointed to a department, the manager must be a full time employee, otherwise reject the update and raise an error message. 2. When a new manager is appointed to a department, the system should make sure that the manager annual salary is >= 100,000 $. If not, then the system should raise the manager's salary to that level. 3. After appointing a new employee(s) to a department(s), the department(s) should recalculate its budget such that the new budget will equal the total salary of all employees who work in that department multiplied by two