Question: 3.2 Using MySQL write a SQL statement that solve the next exercises. A). Fill the tables employees, according with the data given above in E-R

3.2 Using MySQL write a SQL statement that solve the next exercises. A). Fill the tables employees, according with the data given above in E-R Diagram B). Create a stored function named calcTotalSalary. This function takes two input parameters: the Salary and the Commision pct of each Employe. It calculates the Total Salary by sum the salary plus commission pct, and then returns the value to the calling expression (TotalSalary = Salary + commission_pct) C). Please create this stored calcTotalSalary function, run the next MySQL statements to display the results: SELECT *, calcTotalSalary(salary, commission pct) AS TotalSalary FROM employees, (Non-anonymous question)* (15 Points) Table: employees .00 EXPLOTTEID TUTE LANT 100 ing 101 wacha 103 103 Alemd 104 105 ht 104 VII ba DL Lorett 100 ore 101 Det Twit Chen 111 112 113 ROD 103 DAL IPHONE TREATH 0810 BALAY $15.33.440 17-06-17 ADRES 34000.00 MOGA 515.133.4548 17000.00 LDERAAN 13:47:06. ADV 515.133.450) 10024-ADVI 17000.00 MOD 510.623.450 1817-06-30 IT TO 19000.00 BE 580.623.44 17:06:21 11 10 DRONTEN 590.623.449 VIATAAL 50.623.450 19.00-23 BETE 11181-06-24 waste SI5.12416 1 1906-25 STAVIT 535.124.4143 Not 535.176.00 11-06-21 MONT CIMA 515.124.685 17-06-16 DOCENT 700.00 01-04-20 1000.00 35.12. LOR 515.124.4 21-06-30 6990. SARL 315. 2:01: 11000 NA 11070 $15.12.15 PUCURE S8.13 PUGLER 11 NCR COLT 11 11 0.00 9.00 100 0.00 100 0.00 100 0.00 0.00 0.00 . 103 0.00 0.00 103 0.00 100 0.00 8:00 0.00 0.00 0.00 9.00 0.00 3.00 . 0.00 300.00 11 man 110 2000.00 1.00 TO w GE w S123456 -0% 01-09 PLE VOLL 3.10 . 500.00 100.00 200 TOVIA M DO YEN TEL JUAL 10.12 60.12.214 10.12.01 50.13 50.1111 150.12.13 20.114.133: 0.131434 0.23 19 11-01-14 RAM . LEH TUM TC 2100. 300.00 SY . 1.01.18 10. 11
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
