Answer Happy

Posted: **Fri Jul 01, 2022 5:52 am**

: Employee Fname Minit Lname Ssn Bdate Department Dname Dnumber Mgr Ssn Mgr Start Date Aaa Dept Locations Dnumber Dlocatio 1 (47.35 KiB) Viewed 37 times

: Employee Fname Minit Lname Ssn Bdate Department Dname Dnumber Mgr Ssn Mgr Start Date Aaa Dept Locations Dnumber Dlocatio 2 (16.61 KiB) Viewed 37 times

EMPLOYEE Fname Minit Lname Ssn Bdate DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date AAA DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum Address Sex Salary WORKS_ON Essn Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship Super_ssn Dno
c) (10 points) Write a trigger that whenever an employee's project assignments are changed, check if the total hours per week spent on the employee's projects are less than 30 or greater than 40; if so, notify the employee's direct supervisor.