Info
Warning
Danger
/ Homework Answers / Computer Science / Question Each trigger applies to updates as well as inserts. A trigger

Question

Question

Each trigger applies to updates as well as inserts.

  1. A trigger that insures that theASSIGN_HOURS field contains a value that is at least .5 hours andless than 10.0 hours
  2. A trigger that insures that theemployee hire date is not after the current date.  Thecurrent date can be accessed by the getdate()function.
  3. A trigger that insures that the jobcode in the EMPLOYEE table is a valid job code from the jobtable.

Solution
5 (1 Ratings )

Solved
Computer Science 2 Months Ago 36 Views
This Question has Been Answered!
Premium Content -