Employee Fname Minit Lname Ssn Bdate Department Dname Dnumber Mgr Ssn Mgr Start Date Aaa Dept Locations Dnumber Dlocatio 1 (47.35 KiB) Viewed 36 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 36 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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!