Assignment for Triggers & Cursers
See the below tables and solve the given queries.
Table: Employee
|
Employee_id |
First_Name |
Last_Name |
Salary |
Joining_date |
Department |
|
1 |
John |
Abraham |
1000000 |
01JAN13 12.00.00 AM |
Banking |
|
2 |
Michael |
Clarke |
800000 |
01JAN13 12.00.00 AM |
Insurance |
|
3 |
Roy |
Thomas |
700000 |
01FEB1312.00.00 AM |
Banking |
|
4 |
Tom |
Jose |
600000 |
01FEB1312.00.00 AM |
Insurance |
|
5 |
Jerry |
Pinto |
650000 |
01FEB1312.00.00 AM |
Insurance |
|
6 |
Philip |
Mathew |
750000 |
01JAN1312.00.00 AM |
Services |
|
7 |
TestName1 |
123 |
650000 |
01JAN1312.00.00 AM |
Services |
|
8 |
TestName2 |
Lname% |
600000 |
01FEB1312.00.00 AM |
Insurance |
Table: Incentives
|
Employee_ref_id |
Incentive_date |
Incentive_amount |
|
1 |
01-FEB-13 |
5000 |
|
2 |
01-FEB-13 |
3000 |
|
3 |
01-FEB-13 |
4000 |
|
1 |
01-JAN-13 |
4500 |
|
2 |
01-JAN-13 |
3500 |
Questions
- Write a triggers to Log any changes to Incentive table.
- write trigger to check salary > 500000.
- Write trigger to verify age >18 while enrolling employee.
- Write and call cursor for employee table to store employees with incentive.
- Write and call a cursor with incentives in Jan month.
Note:
- Upload screenshots containing query and its output in either jpg or png format.
- Name of screenshot file name must be Question No. i.e. 1.jpg or 1.png.
- Optional questions are not required to submit.