Using Query Builder, select the following 3 data tables (EMPLOYEES, DEPARTMENTS, and JOBS ) with appropriate Primary key - Foreign key relationships between them: EMPLOYEES data table with columns: FIRST_NAME, SALARY, and COMMISSION_PCT. [2 Marks] DEPARTMENTS data table with column: DEPARTMENT_NAME [2 Marks] JOBS data table with column: JOB_TITLE [2 Marks] Define the following new formula-columns based on the given Formula and display them on the Report: [8 Marks] COMME SALARY * COMMISSION_PCT RENT has to be calculated as 10% of the SALARY TAX has to be calculated as 1% of the SALARY TOTAL = SALARY +COMM + RENT - TAX Adjust the width of the above 9 columns, so that all those 9 columns fit properly on each page. [1 Mark] Calculate SUM (Total) and AVERAGE for all the above numeric columns and display it as Grand Total to show them at the end of the Report. [3 Marks] Display JOB_TITLE vice Sub-Total of all the above numeric columns at the bottom of each group of JOB_TITLE on the Report. Show the records of each group on a new page. [3 Marks] On the left side of the Report Header, display your Name_DD. [2 Marks] On the center of the Report Header, display the Current Page Number. [2 Marks] On the center of the Report Footer, display the Query Builder File Name. [2 marks] On the right side of the Report Footer, display the Current Date and Time. [2 Marks] The Query Builder Application should like as follows: Query Builder File Edit Data Query Results Layout Window Help CBX 18 905 646 Sad O N V Xte? Print Preview 27 JOBS 3080 Next Previous Print Cancel DIA BA DIA > LL 308 TITLE MIN SALARY MAX SALARY AU_2009887 Page No 1 ALI 9878787 Query be Query E EMPLOYEES ET EMPLOYEE D FIRST NAME LAST NAME EMAL DIA PHONE NUMBER DA HIRE DATE J08 ID BIA SALARY COMMISSION PCT 0 MANAGER ID 09 DEPARTMENT IDO COMM PCT DOM TOTAL RENT TAX DEPARTMENTS 01 DEPARTMENT ID OP DEPARTMENT NAME DIA MANAGER D LOCATION D 2 JOB TITLE 1 Accountant 2 3 4 5 6 Total 7 Average FIRST NAME SALARY DEPARTMENT NAME COMM PCT COMM RENT TAX TOTAL Daniel 9000 France 0 ol 900 90 9810 Luit 6900 France 0 0 Jose Manuel 7800 France ol 0780 78 6502 ng 7700France ol 0 7701 77 8380 John 8200 France ol ol820 82 8929 39600 0 3960 39643164 7920 0 792 792 86228 Ssss toto 1 ALI_9878787_Query brwi Results JOB TITLE FIRST_NAME SALARY DEPARTMENT_NAME COMM_PCT COMM RENT TAX TOTAL 1 Accountant Denie 9000 France 0 900 90 910 Lut 6900 France 0 0 690 69 7521 3 Jose Manuel 7800 France 0 0 780 78 8502 7700 France 0 0 770 77 8380 John 8200 France 0 0 820 6 Toll 39600 0 0 3360 346 43164 2920 0 0 72 792 88328 8 Accounting Manager Shelley 12000 Accounting 0 0 1200 120 13080 9 Administration Assist Jernie 4400 Administration 0 0 440 44 4796 10 Administration Vice Pres Lex 17000 Executive 0 0 1700 170 18530 11 Neena 17000 Executive 0 0 1700 170 18530 12 Toit 34000 0 0 3400 340 37080 Ooool 7 Average