Question: Question 4 4 Points 1. Create the following table employees. ID 1 2 3 4 5 6 NAME Rashed Khadeeja Fouad Saeed Nada Kamal AGE

Question 4 4 Points 1. Create the following table employees. ID 1 2 3 4 5 6 NAME Rashed Khadeeja Fouad Saeed Nada Kamal AGE 32 25 23 25 27 22 ADDRESS SALARY Dubai 2000.00 Dubai 1500.00 Abu Dhabi 2000.00 Sharjah 6500.00 Dubai 8500.00 Al Ain 4500.00 Create a procedure that: 1. Increase the employees' salary by500. 2. Declares a cursor to include employee's ID, name, and salary. 3. Declare three variables eid, ename, salary with the same datatype as their counterpart in the table employees. 4. For each row of the cursor, assign the values of the cursor to the variables you declared above and print them to the screen. Question 4 4 Points 1. Create the following table employees. ID 1 2 3 4 5 6 NAME Rashed Khadeeja Fouad Saeed Nada Kamal AGE 32 25 23 25 27 22 ADDRESS SALARY Dubai 2000.00 Dubai 1500.00 Abu Dhabi 2000.00 Sharjah 6500.00 Dubai 8500.00 Al Ain 4500.00 Create a procedure that: 1. Increase the employees' salary by500. 2. Declares a cursor to include employee's ID, name, and salary. 3. Declare three variables eid, ename, salary with the same datatype as their counterpart in the table employees. 4. For each row of the cursor, assign the values of the cursor to the variables you declared above and print them to the screen
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
