Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started