Question: Please answer 11 and 12 in detail. Write the SQL code to change the EMP_PCT value to 3.85 for the person whose employee number (EMP_NUM)

Please answer 11 and 12 in detail.
 Please answer 11 and 12 in detail. Write the SQL code

Write the SQL code to change the EMP_PCT value to 3.85 for the person whose employee number (EMP_NUM) is 103. Next, write the SQL command sequences to change the EMP_PCT values, as shown in Figure P79. Using a single command sequence, write the SQL code that will change the project number (PROUNUM) to 18 for all employees whose job classification (JOB CODE) is 500. Using a single command sequence, write the SQL code that will change the project number (PROLNUM) to 25 for all employees whose job classification (JOB CODE) is 502 or higher. When you finish Problems 10 and 11, the EMP_2 table will contain the data shown in Figure P7.11. (You may assume that the table has been saved again at this point) Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January 1, 1994, and whose job code is at least 501. (You may assume that the table will be restored to its condition preceding this question) Write the two SQL command sequences required to: a. Create a temporary table named TEMP_1 whose structure is composed of the EMP_2 attributes EMP_NUM and EMP_PCT b. Copy the matching EMP_2 values into the TEMP_1 table. Write the SQL command that will delete the newly created TEMP_1 table from the database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!