Each trigger applies to updates as well as inserts.
- A trigger that insures that theASSIGN_HOURS field contains a value that is at least .5 hours andless than 10.0 hours
- A trigger that insures that theemployee hire date is not after the current date. Thecurrent date can be accessed by the getdate()function.
- A trigger that insures that the jobcode in the EMPLOYEE table is a valid job code from the jobtable.