RDBMS Assignment 6

ASSIGNMENT 6 SOLUTION WITH SOURCE CODE

Triggers

Contents:

1. Set A
• Q.1
• Q.2
• Q.3
2. Set B
• Q.1
• Q.2
• Q.3

Set A

Q 1. Write a trigger which will fire before insert or update on Investment having investment amount less than 10000. (Raise user defined exception and give appropriate message)

 Download code        Source code 

Q 2. Write a trigger which will fire before insert or update on Employee having Emp id less than equal to zero (Raise user defined exception and give appropriate message)

 Download code        Source code 

Q 3. Write a trigger which will fire before insert or update on Investment having investment date greater than current date. (Raise user defined exception and give appropriate message)

 Download code        Source code 

Set B

Q 1. Write a trigger which will fire before insert or update on Menu having price less than or equal to zero. (Raise user defined exception and give appropriate message)

 Download code        Source code 

Q 2. Write a trigger which will fire before insert or update on Bill having day other than seven week days. (Raise user defined exception and give appropriate message)

 Download code        Source code 

Q 3. Write a trigger which will fire before insert or update on Bill having total less than or equal to 10 Rs. (Raise user defined exception and give appropriate message)

 Download code        Source code