4. Let suppose you have following three 2D arrays named as Worker, Bonus, Title with the...

Transcribed Image Text:

4. Let suppose you have following three 2D arrays named as Worker, Bonus, Title with the given data. There is one common column i.e. Worker ID in all these arrays. Worker: WORKER_ID FIRST_NAME LAST_NAME SALARY JOINING DATE DEPARTMENT 001 Monika Arora 100000 2014-02-20 09:00:00 HR 002 Niharika Verma 80000 2014-06-11 09:00:00 Admin 003 Vishal Singhal 300000 2014-02-20 09:00:00 HR 004 Amitabh Singh 500000 2014-02-20 09:00:00 Admin 005 Vivek Bhati 500000 2014-06-11 09:00:00 Admin 006 Vipul Diwan 200000 2014-06-11 09:00:00 Account 007 Satish Kumar 75000 2014-01-20 09:00:00 Account 008 Geetika Chauhan 90000 2014-04-11 09:00:00 Admin Bonus: Title: WORKER_REF_ID BONUS DATE BONUS_AMOUNT WORKER REF_ID WORKER_TITLE AFFECTED_FROM 1 2016-02-20 00:00:00 5000 1 Manager 2016-02-20 00:00:00 2 Executive 2016-06-11 00:00:00 2 2016-06-11 00:00:00 3000 8 Executive 2016-06-11 00:00:00 3 2016-02-20 00:00:00 4000 Manager 2016-06-11 00:00:00 1 2016-02-20 00:00:00 4500 4 Asst. Manager 2016-06-11 000:00 2016-06-11 00:00:00 3500 7 Executive 2016-06-11 00:00.00 6 Lead 2016-06-11 00:00:00 3 Lead 2016-06-11 00:00:00 Write 'C' programs for each of the following tasks: a. Display the details of the workers having maximum salary of each department. Sample Output: 003 Vishal Singhal 300000 2014-02-20 HR 004 Amitabh Singh 500000 2014-02-20 Admin 006 Vipul Diwan 200000 2014-06-11 Асcount b. Fetch departments along with the total salaries paid for each of them. e.g. Sample Output: HR - 400000 Admin - 1170000 Account - 275000 4. Let suppose you have following three 2D arrays named as Worker, Bonus, Title with the given data. There is one common column i.e. Worker ID in all these arrays. Worker: WORKER_ID FIRST_NAME LAST_NAME SALARY JOINING DATE DEPARTMENT 001 Monika Arora 100000 2014-02-20 09:00:00 HR 002 Niharika Verma 80000 2014-06-11 09:00:00 Admin 003 Vishal Singhal 300000 2014-02-20 09:00:00 HR 004 Amitabh Singh 500000 2014-02-20 09:00:00 Admin 005 Vivek Bhati 500000 2014-06-11 09:00:00 Admin 006 Vipul Diwan 200000 2014-06-11 09:00:00 Account 007 Satish Kumar 75000 2014-01-20 09:00:00 Account 008 Geetika Chauhan 90000 2014-04-11 09:00:00 Admin Bonus: Title: WORKER_REF_ID BONUS DATE BONUS_AMOUNT WORKER REF_ID WORKER_TITLE AFFECTED_FROM 1 2016-02-20 00:00:00 5000 1 Manager 2016-02-20 00:00:00 2 Executive 2016-06-11 00:00:00 2 2016-06-11 00:00:00 3000 8 Executive 2016-06-11 00:00:00 3 2016-02-20 00:00:00 4000 Manager 2016-06-11 00:00:00 1 2016-02-20 00:00:00 4500 4 Asst. Manager 2016-06-11 000:00 2016-06-11 00:00:00 3500 7 Executive 2016-06-11 00:00.00 6 Lead 2016-06-11 00:00:00 3 Lead 2016-06-11 00:00:00 Write 'C' programs for each of the following tasks: a. Display the details of the workers having maximum salary of each department. Sample Output: 003 Vishal Singhal 300000 2014-02-20 HR 004 Amitabh Singh 500000 2014-02-20 Admin 006 Vipul Diwan 200000 2014-06-11 Асcount b. Fetch departments along with the total salaries paid for each of them. e.g. Sample Output: HR - 400000 Admin - 1170000 Account - 275000

Answer rating: 100% (QA)

a Displaying workers having maximum salary maxsalaryc include include include const char Worker4820 001MonikaArora10000020140220 090000HR 002NiharikaV... View the full answer