made table EMPLOYEES and furthermore to refresh compensation, for a particular division ID. -> The method ought
Question:
made table EMPLOYEES and furthermore to refresh compensation, for a particular division ID.
-> The method ought to peruse column by line utilizing unequivocal cursor and compute normal compensation for the gig id that the representative performs.
->On the off chance that the compensation is below the normal peak that work ID, update the representative's compensation to the normal and show old compensation, new compensation, and the distinction.
->Assuming the compensation is higher than the normal, show the compensation and the distinction from the typical compensation for that work id.
->The program ought to work out the aggregate sum of cash that the office will require for the compensation increment for every one of its representatives.
So give an unknown square that will call this strategy for a considerable length of time of division ID.
You can involve the accompanying SQL explanations for testing:
select particular department_id, count(1) from representatives bunch by department_id;
select * from workers where department_id = 50 request by job_id, employee_id;
An illustration of the result is shown roar:
************************************************
Division ID = 50
************************************************
************************************************
Work ID = SH_CLERK - the typical compensation for this occupation id is $3215
************************************************
Representative ID 180, Name = Winston Taylor, the compensation has been refreshed from $3200 to $3215 (added $15).
Worker ID 181, Name = Jean Fleaur, the compensation has been refreshed from $3100 to $3215 (added $115).
Worker ID 182, Name = Martha Sullivan, the compensation has been refreshed from $2500 to $3215 (added $715).
Worker ID 183, Name = Girard Geoni, the compensation has been refreshed from $2800 to $3215 (added $415).
Representative ID 184, Name = Nandita Sarchand, the compensation $4200 is higher than normal $3215 no update (the thing that matters is $985).
Worker ID 185, Name = Alexis Bull, the compensation $4100 is higher than normal $3215 no update (the thing that matters is $885).
Representative ID 186, Name = Julia Dellinger, the compensation $3400 is higher than normal $3215 no update (the thing that matters is $185).
Representative ID 187, Name = Anthony Cabrio, the compensation has been refreshed from $3000 to $3215 (added $215).
Representative ID 188, Name = Kelly Chung, the compensation $3800 is higher than normal $3215 no update (the thing that matters is $585).
Worker ID 189, Name = Jennifer Dilly, the compensation $3600 is higher than normal $3215 no update (the thing that matters is $385).
Worker ID 190, Name = Timothy Gates, the compensation has been refreshed from $2900 to $3215 (added $315).
Worker ID 191, Name = Randall Perkins, the compensation has been refreshed from $2500 to $3215 (added $715).
Worker ID 192, Name = Sarah Bell, the compensation $4000 is higher than normal $3215 no update (the thing that matters is $785).
Worker ID 193, Name = Britney Everett, the compensation $3900 is higher than normal $3215 no update (the thing that matters is $685).
Representative ID 194, Name = Samuel McCain, the compensation has been refreshed from $3200 to $3215 (added $15).
Worker ID 195, Name = Vance Jones, the compensation has been refreshed from $2800 to $3215 (added $415).
Representative ID 196, Name = Alana Walsh, the compensation has been refreshed from $3100 to $3215 (added $115).
Representative ID 197, Name = Kevin Feeney, the compensation has been refreshed from $3000 to $3215 (added $215).
Representative ID 198, Name = Donald OConnell, the compensation has been refreshed from $2600 to $3215 (added $615).
Representative ID 199, Name = Douglas Grant, the compensation has been refreshed from $2600 to $3215 (added $615).
************************************************
Work ID = ST_CLERK - the typical compensation for this occupation id is $2785
************************************************
Representative ID 125, Name = Julia Nayer, the compensation $3200 is higher than normal $2785 no update (the thing that matters is $415).
Representative ID 126, Name = Irene Mikkilineni, the compensation has been refreshed from $2700 to $2785 (added $85).
Worker ID 127, Name = James Landry, the compensation has been refreshed from $2400 to $2785 (added $385).
Representative ID 128, Name = Steven Markle, the compensation has been refreshed from $2200 to $2785 (added $585).
Representative ID 129, Name = Laura Bissot, the compensation $3300 is higher than normal $2785 no update (the thing that matters is $515).
Representative ID 130, Name = Mozhe Atkinson, the compensation $2800 is higher than normal $2785 no update (the thing that matters is $15).
Representative ID 131, Name = James Marlow, the compensation has been refreshed from $2500 to $2785 (added $285).
Worker ID 132, Name = TJ Olson, the compensation has been refreshed from $2100 to $2785 (added $685).
Worker ID 133, Name = Jason Mallin, the compensation $3300 is higher than normal $2785 no update (the thing that matters is $515).
Worker ID 134, Name = Michael Rogers, the compensation $2900 is higher than normal $2785 no update (the thing that matters is $115).
Representative ID 135, Name = Ki Gee, the compensation has been refreshed from $2400 to $2785 (added $385).
Worker ID 136, Name = Hazel Philtanker, the compensation has been refreshed from $2200 to $2785 (added $585).
Representative ID 137, Name = Renske Ladwig, the compensation $3600 is higher than normal $2785 no update (the thing that matters is $815).
Worker ID 138, Name = Stephen Stiles, the compensation $3200 is higher than normal $2785 no update (the thing that matters is $415).
Worker ID 139, Name = John Seo, the compensation has been refreshed from $2700 to $2785 (added $85).
Worker ID 140, Name = Joshua Patel, the compensation has been refreshed from $2500 to $2785 (added $285).
Worker ID 141, Name = Trenna Rajs, the compensation $3500 is higher than normal $2785 no update (the thing that matters is $715).
Worker ID 142, Name = Curtis Davies, the compensation $3100 is higher than normal $2785 no update (the thing that matters is $315).
Worker ID 143, Name = Randall Matos, the compensation has been refreshed from $2600 to $2785 (added $185).
Representative ID 144, Name = Peter Vargas, the compensation has been refreshed from $2500 to $2785 (added $285).
************************************************
Work ID = ST_MAN - the typical compensation for this occupation id is $7280
************************************************
Representative ID 120, Name = Matthew Weiss, the compensation $8000 is higher than normal $7280 no update (the thing that matters is $720).
Representative ID 121, Name = Adam Fripp, the compensation $8200 is higher than normal $7280 no update (the thing that matters is $920).
Representative ID 122, Name = Payam Kaufling, the compensation $7900 is higher than normal $7280 no update (the thing that matters is $620).
Worker ID 123, Name = Shanta Vollman, the compensation has been refreshed from $6500 to $7280 (added $780).
Worker ID 124, Name = Kevin Mourgos, the compensation has been refreshed from $5800 to $7280 (added $1480).
************************************************
Division ID 50 necessities $10590 something else for the compensation increment.
************************************************
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill