• Design and create a report using Reports Builder using the database tables EMPLOYEES, DEPARTMENTS and JOBS.
• Create appropriate relationships [1 to Many] using Primary keys and Foreign keys of the tables EMPLOYEES, DEPARTMENTS and JOBS.
• The Report should be grouped by JOB_ID, JOB_TITLE using the option Group Above.

Save the Report as EMP_DEPT_JOB and also create its executable file.

- X Report Builder for Windows 95/ NT File Edit View Insert Format Arrange Program Tools Window Help Tardi BIVES = + # % Uo0+ 0 15 18 9 - 110 Employee Details *000 AJZ Page 2 abc Job Id DO 2 AD_VP T Job Title Administration Vice President Employee ld First Name Hire Date Manager Id Salary Commission Pct Department ld Department Name 102 Lex 13-JAN-93 100 17000 0 Last Name Email Phone Number De Haan LDEHAAN 515.123.456 9 Kochhar NKOCHHA 515.123.456| R 8 90 Executive 101 Neena 21-SEP-89 100 17000 0 90 Executive G Total: 3 Average: 34000 17000 0 0 Job id 3 FI_ACCOUNT Job Title Accountant Employee ld First Name Last Name Hire Date Manager Id Salary Commission Pct Department ld Department Name 110 John Chen 28-SEP-97 108 8200 0 100 Finance 109 Daniel Faviet 16-AUG-94 108 9000 0 100 Finance Email Phone Number JCHEN 515.124.426 9 DFAVIET 515.124.416 9 LPOPP 515.124.456 7 ISCIARRA 515.124.436 9 JMURMAN 515.124.446 9 113 Luis Popp 07-DEC-99 108 6900 0 100 Finance 111 Ismael Sciarra 30-SEP-97 108 7700 0 100 Finance 112 Jose Manuel Urman 07-MAR-98 108 7800 0 0 100 Finance Total: Average: 39600 7920 0 0 Q 1x 4.25 3.88 1 Type here to search i w wi A ENG 4:15 AM 5/18/2020 731 Share Paste 15111-Assignment-d6a6fc17152271563357151290412178 - Word Home Insert Design Layout References Mailings Review View Tell me what you want to do.. X Cut Times New R 12 - A A A - TEEMA Ex Copy Bbccod . : BI U XX A. A. Heading 3 1 Normal 1 No Space Heading 1 Heading 2 Heading 4 Title Formal Painter Subtitle Subtle Em. Emphasis Clipboard Paragraph Select all yenew OSCYTOLIKI COLCE TO THE TOETmu so musert a ground picture ou Save the Form as JOB_HISTORY and also create its executable file. Task 2 [05][10 Marks] Question No. 2 Find - Replace Select Eiting . Page 4 of 8 Design and create a form to display data records from the Primary Key Table DEPARTMENTS with its Canvas Type as Tab. Create another data block on the same form moclule to display data records from the Foreign Key Table EMPLOYEES with appropriate relationships (I to Many using Primary key and Foreign key of the tables EMPLOYEES and DEPARTMENTS on the same Canvas, but with a New Tab Page. Its canvas type should be Tabular with Record Displayed as 10. Add at least 4 command push buttons on the DEPATMENTS tab page to Exit, Call Chart: EMP_ENAME_SALARY, Call Report: EMP_DEPT_JOB, and to Call Form: JOB HISTORY Select dark yellow background color for the tab DEPARTMENTS with a picture on it, and select magenta background color for the tab EMPLOYEES and also insert a background picture on it. Save the Form as DEPT_EMP and also create its executable tile. Task 3 [06] [10 Marks) auctis Na ? Page 4 of 7 of 93 words English (United States) + 100% 209 AM Type here to search EH f w Oua) ENG IM 1/7/2021 - X Report Builder for Windows 95/ NT File Edit View Insert Format Arrange Program Tools Window Help Tardi BIVES = + # % Uo0+ 0 15 18 9 - 110 Employee Details *000 AJZ Page 2 abc Job Id DO 2 AD_VP T Job Title Administration Vice President Employee ld First Name Hire Date Manager Id Salary Commission Pct Department ld Department Name 102 Lex 13-JAN-93 100 17000 0 Last Name Email Phone Number De Haan LDEHAAN 515.123.456 9 Kochhar NKOCHHA 515.123.456| R 8 90 Executive 101 Neena 21-SEP-89 100 17000 0 90 Executive G Total: 3 Average: 34000 17000 0 0 Job id 3 FI_ACCOUNT Job Title Accountant Employee ld First Name Last Name Hire Date Manager Id Salary Commission Pct Department ld Department Name 110 John Chen 28-SEP-97 108 8200 0 100 Finance 109 Daniel Faviet 16-AUG-94 108 9000 0 100 Finance Email Phone Number JCHEN 515.124.426 9 DFAVIET 515.124.416 9 LPOPP 515.124.456 7 ISCIARRA 515.124.436 9 JMURMAN 515.124.446 9 113 Luis Popp 07-DEC-99 108 6900 0 100 Finance 111 Ismael Sciarra 30-SEP-97 108 7700 0 100 Finance 112 Jose Manuel Urman 07-MAR-98 108 7800 0 0 100 Finance Total: Average: 39600 7920 0 0 Q 1x 4.25 3.88 1 Type here to search i w wi A ENG 4:15 AM 5/18/2020 731 Share Paste 15111-Assignment-d6a6fc17152271563357151290412178 - Word Home Insert Design Layout References Mailings Review View Tell me what you want to do.. X Cut Times New R 12 - A A A - TEEMA Ex Copy Bbccod . : BI U XX A. A. Heading 3 1 Normal 1 No Space Heading 1 Heading 2 Heading 4 Title Formal Painter Subtitle Subtle Em. Emphasis Clipboard Paragraph Select all yenew OSCYTOLIKI COLCE TO THE TOETmu so musert a ground picture ou Save the Form as JOB_HISTORY and also create its executable file. Task 2 [05][10 Marks] Question No. 2 Find - Replace Select Eiting . Page 4 of 8 Design and create a form to display data records from the Primary Key Table DEPARTMENTS with its Canvas Type as Tab. Create another data block on the same form moclule to display data records from the Foreign Key Table EMPLOYEES with appropriate relationships (I to Many using Primary key and Foreign key of the tables EMPLOYEES and DEPARTMENTS on the same Canvas, but with a New Tab Page. Its canvas type should be Tabular with Record Displayed as 10. Add at least 4 command push buttons on the DEPATMENTS tab page to Exit, Call Chart: EMP_ENAME_SALARY, Call Report: EMP_DEPT_JOB, and to Call Form: JOB HISTORY Select dark yellow background color for the tab DEPARTMENTS with a picture on it, and select magenta background color for the tab EMPLOYEES and also insert a background picture on it. Save the Form as DEPT_EMP and also create its executable tile. Task 3 [06] [10 Marks) auctis Na ? Page 4 of 7 of 93 words English (United States) + 100% 209 AM Type here to search EH f w Oua) ENG IM 1/7/2021