حل تشریحی سوال شماره 114 پایگاه داده‌ها

CREATE ASSERTION Salary Budget Cheek

CHECK ( NOT EXISTS ( SELECT E.Department ID FROM Employees

E WHERE SUM (E.Salary) > (SELECT D.Budget

FROM Departments D WHERE D.Department ID = E.Department ID)));

CREATE ASSERTION Salary Budget Cheek AS CHECK

( SELECT SUM (E.Salary) FROM Employees E GROUP BY E.

Department ID$\Leftarrow$ SELECT D. Budget FROM Departments D

WHERE D.Department ID = E.Department ID);

GREATE TRIGGER Salary Budget Check BIFORE INSERT OR UPDATE ON Employees FOR EACH ROW EXECUTE RPOCEDURE Cheek Salary Budget();