CREATE TRIGGER TotalSalary
AFTER INSERT OR UPDATE OF salary ON staff
FOR EACH STATEMENT
WHEN
(EXISTS (SELECT *
FROM dept
WHERE name = NEW.dname
AND budget < (SELECT sum(salary)
FROM staff
WHERE dname = NEW.dname)
)
)
INFORM_MANAGER(NEW.dname, NEW.name, NEW.salary);
E