Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table in the Ch07_ConstructCo database. (See Figure P7.1.) Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS.

Relational diagram JOE CODE DE DESCRIPTION 105 CHG HOUR 105 LAST UPDATE ASSIGNMENT Y ASSIGN NUM ASSIGN_DATE PROJ NUM EMP NUM ASSIGN JOB ASSIGN_CHG_HR ASSIGN HOURS ASSIGN CHARGE V EMP. NUN PROJECT 9 PROJ_NUM PROI NAME PROJ, VALUE PROLBALANCE EMP_NUM EMP. PREDATE 108 CODE EMP YEARS Table name: JOB CODE 50 SI 53 52 505 JOB_DESCRIPTION Programmer Systems Analyst Database Designer Electrical Engineer Mechanical Engineer Civil Engineer Clerical Support DSS Analyst Applications Designer Bio Technician General Support JOB_CHO_HOUR JOB LAST UPDATE 35.75 20-Nov 15 96.75 20-Nov-15 125.00 24-Mar-16 84.50 20-Nov-15 67.90 20-Nov-15 55.78 20-Nov-15 26.87 20-Nov-15 45.95 20-Nov-15 48.10 24-Mar-16 34.55 20-Nov-15 18.36 20-Nov-15 506 507 508 509 510 Table name: PROJECT PROJ_NUM PROJ_NAME 15 Evergreen 18 Amber Wave Rolling Tide PROJ VALUE 1453500.00 3500500.00 805000.00 2650500.00 22 25 PROJ BALANCE EMP_NUM 1002350.00 103 2110346.00 108 500345.20 102 2309880.00 107 Starflight Table name: EMPLOYEE Database name: Ch07_ConstructCo EMP INITIAL EMP NUM EMP LNAME EMP FNAME 101 News John 102 Senior David 103 Arbough 104 Ramoras 105 Johnson 106 Smithfield 107 Alonzo 108 Washington 109 Smith Larry 110 Olenko Geraid 111 Wabash Geoff 112 Smithson Darlene 113 Joenbrood Delbert 114 Jones Annelise 115 Bawangi Travis 116 Pratt Gerald 117 Williamson Angie 118 Frommer James W A EMP HIREDATE JOB CODE EMP_YEARS 08-Nov-00 502 12 12-Jul-89 501 23 01-Dec-96 500 18 15-Nov-87 501 25 01-Feb-93 502 19 22-Jun-04 500 8. 10-Oct-93 500 19 22-Aug-91 501 21 18-Jul-97 501 15 11-Dec-95 505 17 04-Apr-91 506 21 23-Oct-94 507 18 15-Nov-96 508 16 20-Aug-93 508 19 25-Jan-92 501 20 05-Mar-97 510 15 19-Jun-96 509 16 04-Jan-05 510 7 M K L H Table name: ASSIGNMENT ASSION_NUM ASSIGN_DATE PROJ_NUM EMPNUM ASSIGN JOB ASSIGN CHO HRASSIGN HOURS ASSIGN CHARGE 1001 22-Mar-16 18 103 503 84.50 3.5 1002 295.75 22-Mar-16 22 117 509 34.55 4.2 1003 22-Mar-16 18 145.11 117 509 34.55 2.0 89 10 22-Mar-16 18 103 503 84.50 5.9 498.55 1005 22-Mar-16 25 108 501 96.75 22 212.85 1006 22-Mar-16 22 104 96.75 42 406.35 1007 22-Mar-16.25 113 508 50.75 3.8 192.85 1008 22-Mar-16 18 103 503 84.50 0.9 76.05 1009 23-Mar-16 15 115 96.75 5.6 541 80 1010 23-Mar-16 15 509 34.55 2.4 82.92 1011 23-Mar-16.25 105.00 4.3 451 50 23-Mar-16 18 96.75 3.4 328.95 1013 23-Mar-16 25 96.75 2.0 193.50 1014 23-Mar-16 22 96.75 2.8 270.90 1015 23-Mar-16/15 109 84.50 6.1 515.45 1016 23-Mar-16 22 105 502 105.00 4.7 493.50 1017 23-Mar-16 18 117 509 34.55 3.8 131.29 1018 23-Mar-16 25 117 509 34.55 22 76.01 1019 24-Mar-16.25 104 501 110.50 4.9 541.45 1020 24-Mar-16.15 101 502 125.00 3.1 387.50 1021 24-Mar-16 22 108 501 110.50 2.7 298.35 1022 24-Mar-16 22 115 501 110.50 4.9 541.45 1023 24-Mar-16.22 105 502 125.00 3.5 437 50 1024 24-Mar-16 15 103 503 84.50 3.3 278.85 1025 24-Mar-16 18 117 509 34.55 4.2 145.11 1012