Using the EMP_2 table, write the SQL command to add .15 to the EMP_PCT of the employee whose name is Maria D. Alonzo. (Use the employee name in your command to determine the correct employee.)

My code:

And these are the results

 

Transcribed Image Text:

FIGURE P8.1 THE CH08_CONSTRUCTCO DATABASE Database name: Ch08 ConstructCo Relational diagram Table name: EMPLOYEE EMP_NUM EMP LNAME EMP FNAME EMP_INITIAL EMP_HIREDATE JOB_CODE EMP_YEARS JOB ASSIGNMENT Y JOE CODE Y ASSIGN_NUM 101 News John G 08-Nov-00 502 12 JOB_DESCRIPTION ASSIGN_DATE 102 Senior David H 12-Jul-89 501 23 PROJ_NUM EMP NUM JOB_CHG_HOUR JOB_LAST UPDATE 103 Arbough June E 01-Dec-96 500 18 ASSIGN_JOB ASSIGN_CHG_HR 104 Ramoras Anne K 15-Nov-87 501 25 ASSIGN_HOURS ASSIGN_CHARGE 105 Johnson Alice 01-Feb-93 502 19 22-Jun-04 500 PROJECT Y PROJ NUM 106 Smithfield William 8 EMPLOYEE * EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB_CODE EMP VEARS 107 Alonzo Maria D 10-Oct-93 500 19 PROJ_NAME PROJ VALUE Washington 22-Aug-91 501 108 Ralph B 21 PROJ_BALANCE 109 Smith 18-Jul-97 501 15 Larry Gerald EMP_NUM 110 Olenko A 11-Dec-95 505 17 111 Wabash Geoff B 04-Apr-91 506 21 112 Smithson Darlene 23-Oct-94 507 18 113 Joenbrood Delbert K 15-Nov-96 508 16 Table name: JOB 114 Jones Annelise 20-Aug-93 508 19 Travis Gerald 115 Bawangi B 25-Jan-92 501 20 JOB_CODE JOB DESCRIPTION JOB_CHG_HOUR JOB LAST UPDATE 116 Pratt L 05-Mar-97 510 15 500 Programmer 35.75 20-Nov-17 117 Williamson Angie 19-Jun-96 509 16 501 Systems Analyst 96.75 20-Nov-17 502 125.00 118 Frommer James J 04-Jan-05 510 7 Database Designer Electrical Engineer 24-Mar-18 503 84.50 20-Nov-17 Table name: ASSIGNMENT 504 Mechanical Engineer 67.90 20-Nov-17 ENOV-17 Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 505 Civil 55.78 20-Nov-17 ASSIGN_NUM ASSIGN_DATE PROJ_NUM EMP_NUM ASSIGN_JOB ASSIGN_CHG_HR ASSIGN_HOURS ASSIGN_CHARGE U-NoV-17 506 26.87 20-Nov-17 1001 22-Mar-18 18 103 503 84.50 3.5 295.75 507 45.95 20-Nov-17 1002 22-Mar-18 22 117 509 34.55 4.2 145.11 508 48.10 24-Mar-18 22-Mar-18 18 22-Mar-18 18B 1003 117 509 34.55 2.0 69.10 509 34.55 20-Nov-17 1004 103 503 84.50 5.9 498.55 510 18.36 20-Nov-17 1005 22-Mar-18 25 108 501 96.75 2.2 212.85 1006 22-Mar-10 22 104 501 96.75 4.2 406.35 1007 22-Mar-18 25 113 508 50.75 3.8 192.85 1008 22-Mar-18 18 103 503 84.50 0.9 76.05 1009 23-Mar-18 15 115 501 96.75 5.6 541.80 Table name: PROJECT 1010 23-Mar-18 15 117 509 34.55 2.4 82.92 1011 PROJ_NUM PROJ NAME 23-Mar-18 25 105 502 105.00 4.3 451.50 PROJ VALUE PROJ BALANCE EMP_NUM 1012 23-Mar-18 18 108 501 96.75 3.4 328.95 15 Evergreen 1453500.00 1002350.00 103 1013 23-Mar-18 25 115 501 96.75 2.0 193,50 18 Amber Wave 3500500.00 2110346.00 108 1014 23-Mar-18 22 104 501 96.75 2.8 270.90 Rolling Tide Starflight 22 805000.00 500345.20 102 1015 23-Mar-18 15 103 503 84.50 6.1 515.45 25 2650500.00 2309880.00 107 1016 23-Mar-18 22 105 502 105.00 4.7 493.50 1017 23-Mar-18 18 117 509 34.55 3.8 131.29 1018 23-Mar-18 25 117 509 34.55 2.2 76.01 1019 24-Mar-18 25 104 501 110.50 4.9 541.45 1020 24-Mar-18 15 101 502 125.00 3.1 387.50 1021 24-Mar-18 22 108 501 110.50 2.7 298.35 1022 24-Mar-18 22 115 501 110,50 4.9 541.45 1023 24-Mar-18 22 105 502 125.00 3.5 437.50 1024 24-Mar-18 15 103 503 84.50 3.3 278.85 1025 24-Mar-18 18 117 509 34.55 4.2 145.11 FIGURE P8.1 THE CH08_CONSTRUCTCO DATABASE Database name: Ch08 ConstructCo Relational diagram Table name: EMPLOYEE EMP_NUM EMP LNAME EMP FNAME EMP_INITIAL EMP_HIREDATE JOB_CODE EMP_YEARS JOB ASSIGNMENT Y JOE CODE Y ASSIGN_NUM 101 News John G 08-Nov-00 502 12 JOB_DESCRIPTION ASSIGN_DATE 102 Senior David H 12-Jul-89 501 23 PROJ_NUM EMP NUM JOB_CHG_HOUR JOB_LAST UPDATE 103 Arbough June E 01-Dec-96 500 18 ASSIGN_JOB ASSIGN_CHG_HR 104 Ramoras Anne K 15-Nov-87 501 25 ASSIGN_HOURS ASSIGN_CHARGE 105 Johnson Alice 01-Feb-93 502 19 22-Jun-04 500 PROJECT Y PROJ NUM 106 Smithfield William 8 EMPLOYEE * EMP NUM EMP LNAME EMP FNAME EMP INITIAL EMP HIREDATE JOB_CODE EMP VEARS 107 Alonzo Maria D 10-Oct-93 500 19 PROJ_NAME PROJ VALUE Washington 22-Aug-91 501 108 Ralph B 21 PROJ_BALANCE 109 Smith 18-Jul-97 501 15 Larry Gerald EMP_NUM 110 Olenko A 11-Dec-95 505 17 111 Wabash Geoff B 04-Apr-91 506 21 112 Smithson Darlene 23-Oct-94 507 18 113 Joenbrood Delbert K 15-Nov-96 508 16 Table name: JOB 114 Jones Annelise 20-Aug-93 508 19 Travis Gerald 115 Bawangi B 25-Jan-92 501 20 JOB_CODE JOB DESCRIPTION JOB_CHG_HOUR JOB LAST UPDATE 116 Pratt L 05-Mar-97 510 15 500 Programmer 35.75 20-Nov-17 117 Williamson Angie 19-Jun-96 509 16 501 Systems Analyst 96.75 20-Nov-17 502 125.00 118 Frommer James J 04-Jan-05 510 7 Database Designer Electrical Engineer 24-Mar-18 503 84.50 20-Nov-17 Table name: ASSIGNMENT 504 Mechanical Engineer 67.90 20-Nov-17 ENOV-17 Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support 505 Civil 55.78 20-Nov-17 ASSIGN_NUM ASSIGN_DATE PROJ_NUM EMP_NUM ASSIGN_JOB ASSIGN_CHG_HR ASSIGN_HOURS ASSIGN_CHARGE U-NoV-17 506 26.87 20-Nov-17 1001 22-Mar-18 18 103 503 84.50 3.5 295.75 507 45.95 20-Nov-17 1002 22-Mar-18 22 117 509 34.55 4.2 145.11 508 48.10 24-Mar-18 22-Mar-18 18 22-Mar-18 18B 1003 117 509 34.55 2.0 69.10 509 34.55 20-Nov-17 1004 103 503 84.50 5.9 498.55 510 18.36 20-Nov-17 1005 22-Mar-18 25 108 501 96.75 2.2 212.85 1006 22-Mar-10 22 104 501 96.75 4.2 406.35 1007 22-Mar-18 25 113 508 50.75 3.8 192.85 1008 22-Mar-18 18 103 503 84.50 0.9 76.05 1009 23-Mar-18 15 115 501 96.75 5.6 541.80 Table name: PROJECT 1010 23-Mar-18 15 117 509 34.55 2.4 82.92 1011 PROJ_NUM PROJ NAME 23-Mar-18 25 105 502 105.00 4.3 451.50 PROJ VALUE PROJ BALANCE EMP_NUM 1012 23-Mar-18 18 108 501 96.75 3.4 328.95 15 Evergreen 1453500.00 1002350.00 103 1013 23-Mar-18 25 115 501 96.75 2.0 193,50 18 Amber Wave 3500500.00 2110346.00 108 1014 23-Mar-18 22 104 501 96.75 2.8 270.90 Rolling Tide Starflight 22 805000.00 500345.20 102 1015 23-Mar-18 15 103 503 84.50 6.1 515.45 25 2650500.00 2309880.00 107 1016 23-Mar-18 22 105 502 105.00 4.7 493.50 1017 23-Mar-18 18 117 509 34.55 3.8 131.29 1018 23-Mar-18 25 117 509 34.55 2.2 76.01 1019 24-Mar-18 25 104 501 110.50 4.9 541.45 1020 24-Mar-18 15 101 502 125.00 3.1 387.50 1021 24-Mar-18 22 108 501 110.50 2.7 298.35 1022 24-Mar-18 22 115 501 110,50 4.9 541.45 1023 24-Mar-18 22 105 502 125.00 3.5 437.50 1024 24-Mar-18 15 103 503 84.50 3.3 278.85 1025 24-Mar-18 18 117 509 34.55 4.2 145.11

Answer rating: 100% (QA)

UPADATE EMP2 SE... View the full answer