Close Icon
Info
Warning
Danger
 / 
 / 
 / 
Question Each trigger applies to updates as well as inserts. A trigger
Not my Question
Bookmark
Flag Content

Question : Question Each trigger applies to updates as well as inserts. A trigger : 867365

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 10 Months Ago 115 Views
This Question has Been Answered!
Unlimited Access
Explore More than 2 Million+
  • Textbook Solutions
  • Flashcards
  • Homework Answers
  • Documents
Signup for Instant Access!
Ask an Expert
Our Experts can answer your tough homework and study questions
154049 Computer Science Questions Answered!
Post a Question