(Solved) : Given Structures Contents Constructco Database Shown Figure Use Sql Commands Answer Questi Q36781910 . . .
Given the structures and contents of the ConstructCo database shown in the Figure below, use SQL commands to answer the questions. Database name: Ch08 ConstructCo Relational diagram Table name: EMPLOYEE EMP OB LAST UPOATE EMP NUM Table name: JOB TE Table name: ASSIGNMENT CHO Table name: PROJECT PROJ NUM PROJ NAME PROJ VALUE PROJ EMP NUM 1453500 00 3500500.00 80500000 2650500.00 1002350 00 103 2110348 00 108 2309880 00 107 20. Using the EMP 2 table, write the SQL code to add 0.15 to the EMP_PCT of the employee whose name is Maria D. Alonzo. 21. Using a single command sequence with the EMP2 table, write SQL code that will change the project number to 18 for all employees whose job classification (JOB CODE) is 500. 22. Using a single command sequence with the EMP2 table, write SQL code will change the project number to 25 for all employees whose job classification is 502 or higher. 23. 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 Show transcribed image text
Expert Answer
Answer to Given Structures Contents Constructco Database Shown Figure Use Sql Commands Answer Questi Q36781910 . . .
OR