Create an INSTEAD OF trigger on INSERT Session Hours to enforce the rule that no

Question

Create an INSTEAD OF trigger on INSERT Session Hours to enforce the rule that no tutor should work more than 60 hours in a month.
Follow steps if not sure.
1. Get the date from the INSERTED table.
2. Extract the month.
3. Create a variable for the total hours.
4. Assign to total the sum of each session for that month (assuming 30 minutes each).
5. Check to see if the sum > 60. 6. Check if it is output a message.
7. Otherwise complete the insert into the Session table.

Session SessionDate Key Session Timeky TuterKey Coursekey Sladen key sesslon statusSessionMatertaiCoverad 10/20/2009 10/20/2009 11/20/2009 11/5/2009 11n0200s 11/10/2008 1M5/2010 1/21/2010 1/7220120 2/5/2010 2/10/2010 210/20t0 2/13/2010 2/14/2010 14:00 980010001EB110 980010003 ITC110 98010001 T220 98010001 T22 980010004 MAT107 80010001WEB110 980010002ITC255 980010002 ENG211 980010004 MAT107 990001000 C 990001000 C 99000102 | c Nuil 990001004 C 99000100 IC 99000100 IC 990001003c 990001005 NS 990001000 Null CSS For naxt loop Relations Null Bunary Numbers Web Forms Use Gasas Document sructure Null Feasiblilly Null Null Null Null 10:30 10:00 13:00 14:00 11:00 14:00 1030 13.30 14:00 1000 11:00 9901002 n5 980010004 HAT107 980010004MAT107 980010002ITC255 980010002 ENG21 Nu Null Null Nul

Explanation / Answer

trigger on INSERT Session Hours

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.