undefined

Q3. 8 marks CL04 1. Create the following table employees. id name age address salary 1 Rashed 32 Dubai 2500 2 Khadija 25 Dubai 2000 3 Fouad 23 Abu Dhabi 2500 4 Saeed 25 Sharjah 7000 5 Nada 27 Dubai 9000 6 Kamal 22 Al Ain 5000 Create a procedure that: 2. Declares a cursor to include employee's ID, his age and address. 3. Declare three variables theid, theage, thesalary 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. 5. Print them to the screen. 6. Calculate and print the salary average of employees. Q3. 8 marks CL04 1. Create the following table employees. id name age address salary 1 Rashed 32 Dubai 2500 2 Khadija 25 Dubai 2000 3 Fouad 23 Abu Dhabi 2500 4 Saeed 25 Sharjah 7000 5 Nada 27 Dubai 9000 6 Kamal 22 Al Ain 5000 Create a procedure that: 2. Declares a cursor to include employee's ID, his age and address. 3. Declare three variables theid, theage, thesalary 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. 5. Print them to the screen. 6. Calculate and print the salary average of employees