Question

1 Approved Answer

Posted on Sep 22, 2024

Question No. 3 Design and create a Menu using Forms Builder and link the menu with relevant Tables, Forms, Graphics, Reports, etc. to integrate different

Question No. 3

Design and create a Menu using Forms Builder and link the menu with relevant Tables, Forms, Graphics, Reports, etc. to integrate different parts of the project into an application.

The Menu should look like one as given below:

File Record Data

Execute Query First Record Call Chart: EMP_ENAME_SALARY

Enter Query Previous Record Call Report: EMP_DEPT_JOB

_____________ _____________ _______________________

Exit Next Record Call Form: JOB_HISTORY

Last Record

Save the Menu as DEPT_EMP_MENU and also create its executable file.

EMPLOYEES Tab of the Form DEPT_EMP at design time may looks like the one as given below: image text in transcribed DEPARTMENTS Tab of the Form DEPT_EMP at design time may looks like the one as given below:

The Form JOB_HISTORY at design time may looks like the one as given below:

image text in transcribed The Menu, DEPT_EMP_MENU at design time may looks like the one as given below:Question No. 3 [O5][2 Marks] Design and create a form to display data records from the table JOB_HISTORY. The layout style should be Tabular with Record Displayed as 10 Select an yellow background color for the form and also insert a background picture on it. Save the Form as JOB_HISTORY and also create its executable file.

i need all that in zip please in my email

- Oracle Forms Builder - D:Courses_Sem1_2017-'18\441DBMS\441 Assignment DBMS\A3\DEPT_EMP.fmb File Edit View Format Arrange Program Tools Window Help Objec DEPT_EMP: CANVAS2 (DEPARTMENTS) x CANVI OZY Canvas: CANVAS2 Block: DEPARTMENTS ? T Segoe UI 9 BI U P 1116 132 48 164 80 96 112,128144160 176192120812241240|256|2721288 304 3203361 352 368 384 400 416,432448 464 480 496,512 528544 560 576592608624640656672688 704720736 752 768 784 800 8168321848 0 DEPARTMENTS EMPLOYEES 16 32 48 Email 64 M7 80 EMAIL EMAIL EMAIL COMO HO00 Employee ld EMPLOYEE_ID EMPLOYEE ID EMPLOYEE ID EMPLOYEE_ID EMPLOYEE_ID EMPLOYEE ID 96 OX 112 abc 128 First Name FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST NAME FIRST_NAME Last Name LAST_NAME LAST_NAME LAST_NAME LAST_NAME LAST_NAME LAST_NAME LAST NAME LAST_NAME LAST_NAME LAST_NAME EMAIL EMAIL EMAIL Phone Number PHONE NUMBER PHONE_NUMBER PHONE NUMBER PHONE NUMBER PHONE_NUMBER PHONE NUMBER PHONE NUMBER PHONE_NUMBER PHONE_NUMBER PHONE_NUMBER Hire Date HIRE DATE HIRE_DATE HIRE_DATE HIRE DATE HIRE DATE HIRE DATE HIRE DATE HIRE_DATE HIRE DATE HIRE_DATE Job Id Salary Commission Pct Manager IdDepartment Id JOB SALA COM MAN DEPA JOB I SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB I SALA COM MAN DEPA JOB I SALA COM MAN DEPA JOB SALA COM MAN DEPA ZIK 144 OLE OCX 160 abc 176 TYZ + EMPLOYEE_ID EMPLOYEE ID EMPLOYEE_ID EMPLOYEE_ID EMAIL EMAIL EMAIL EMAIL 208 224 240 T 256 272 288 304 Q 1x 2.25 1 193.50 Is canvas raised if user navigates to an item that is hidden by another ca Mod: DEPT_EMP File: 1 Assignment DBMSV43\DEPT_EMP.fmb j Type here to search mm x] 01:57 AM 17/05/2020 131 - x x Block: ? 8 $8: Oracle Forms Builder - D:\Courses_Sem1_2017-'18\441DBMS\441 Assignment DBMS\A3\DEPT_EMP.fmb File Edit View Navigator Program Tools Window Help Object Navigator 0 x DEPT_EMP: CANVASZ (DEPARTMENTS) WINDOW1 Find: DOU OZK Canvas: CANVASZ 2- Forms -DEPT_EMP T Segoe UI BIU Triggers Alerts 4 116 13: 195 Attached Libraries DEPARTMENTS EMPLOYEES + Data Blocks Canvases 82 CANVAS Tab Pages DEPARTMEN DEPARTMENTS Graphics DEPARTMENT_NAME O FRAME4 gerid MANAGER_ID IMAGE11 LOLION LOCATION || -EMPLOYEES -Editors O-LOVS Object Groups -Parameters Call Chart: EMP_ENAME SALARY Call Report: EMP_DEPT_JOB Popup Menus Program Units .- Property Classes -Record Groups 2.88 - Reports Visual Attributes Windows O WINDOW1 0 Menus O-PL/SQL Libraries -Object Libraries Built-in Packages # Database Objects Q 1x 267.75 226.50 COOHO00 GOLO 60X E100 Call Form: JOB_HISTORY Title to be displayed for the object. Mod: DEPT_EMP File: 1 Assignment DBMSV43\DEPT_EMP.fmb Type here to search xo 01:57 AM 17/05/2020 131 - x Canvas: CANVAS Canvas: CANVAS P -Triggers Canvases Oracle Forms Builder - D:\Courses_Sem1_2017-'18\441DBMS\441 Assignment DBMS\A3VOB_HISTORY.fmb File Edit View Format Arrange Program Tools Window Help Object Navigator O x 9 DEPT_EMP: CANVASZ (DEPARTMENTS) x CANVASZ Find: DOO Block: DEPARTMENTS ? Popup Menus T Segoe UI 9 BIU 3 i Ht yli 1 P Program Units Property Classes 13 116 132 148 164 180196 1112,128 144/160/176|1922081224/240256|272/2883041320 336|352|368 384 400 416/432/4481464/480 496/512528544560576592114 -Record Groups JOB_HISTORY: CANVAS (JOB_HISTORY) ox Reports - Visual Attributes DO X Block: JOB_HISTORY ? . Windows WINDOW1 T Segoe UI 9 BIU i Htuli JOB_HISTORY 0 16 132 148 164 80 96 112,128144160176 192 304 320 336352 368 384 400 416432448 464 480 496512528544560 Alerts - Attached Libraries + Data Blocks Employeeld Start Date End Date Job ld Department Id EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN Editor's EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN LOV EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN EMPLOYEE_ID START_DATE END_DATE JOB_ID - Parameters DEPARTMEN Popup Menus X 112 EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN Program Units o abc 128 EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN Property Classes 144 EMPLOYEE ID START_DATE END_DATE JOB ID DEPARTMEN - Record Groups 160 EMPLOYEE_ID START_DATE END DATE JOB_ID DEPARTMEN Reports 0- Visual Attributes abc 176 EMPLOYEE_ID START_DATE END DATE JOB_ID DEPARTMEN # Windows EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN Menus E DEPT_EMP_MENU EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN - Attached Libraries Menus MENU1 Items LT FILE CANVAS2 O-LOVS Object Groups Q 1x 0.00 19 0.00 Mod: JOB_HISTORY File: ssignment DBMSVAGWOB_HISTORY.fmb Type here to search WILL 01:59 AM 17/05/2020 731 - x Block Oracle Forms Builder - DA Courses_Sem1_2017-'181441DBMS 441 Assignment DBMS\A3\DEPT_EMP_MENU.mmb File Edit Menu Program Tools Window Help Object Navigator O x I DEPT_EMP: CANVASZ (DEPARTMENTS x DATA Find: DOO Canvas: CANVAS ? Iriggers T Segoe UI BIU P 0-Alerts -Attached Libraries 116 132 48 64 80 96 1127128144160 176192 2081224/240256|272289304|320336352 368 384 400 416 432448464480 4965125285445605765921 # Data Blocks Canvases 16 CANVASZ DEPT_EMP_MENU: Menu Editor O O IX Tab Pages Display Menu: MENU1 TE 6-DEPARTMENTS .- Graphics File A Record Data A OFRAME4 Execute Query IMAGE11 First Record Call Chart: EMP_ENAME_SALARY #-EMPLOYEES Enter Query Previous Record Call Report: EMP_DEPT_JOB -Editors Exit Next Record Call Form: JOB_HISTORY -Object Groups Last Record .- Parameters "Popup Menus "Program Units -Property Classes -Record Groups -Reports Visual Attributes Windows CE O WINDOW1 Menus E DEPT_EMP_MENU -Attached Libraries Menus MENU1 Items FILE Q 1x 122.25 0.75 U RECORD DATA E DATA O-LOVS Mod: DEPT_EMP_MENU File: ignment DBMSV3 DEPT_EMP_MENU.mmb Type here to search o jj xo 01:58 AM 17/05/2020 131 - Oracle Forms Builder - D:Courses_Sem1_2017-'18\441DBMS\441 Assignment DBMS\A3\DEPT_EMP.fmb File Edit View Format Arrange Program Tools Window Help Objec DEPT_EMP: CANVAS2 (DEPARTMENTS) x CANVI OZY Canvas: CANVAS2 Block: DEPARTMENTS ? T Segoe UI 9 BI U P 1116 132 48 164 80 96 112,128144160 176192120812241240|256|2721288 304 3203361 352 368 384 400 416,432448 464 480 496,512 528544 560 576592608624640656672688 704720736 752 768 784 800 8168321848 0 DEPARTMENTS EMPLOYEES 16 32 48 Email 64 M7 80 EMAIL EMAIL EMAIL COMO HO00 Employee ld EMPLOYEE_ID EMPLOYEE ID EMPLOYEE ID EMPLOYEE_ID EMPLOYEE_ID EMPLOYEE ID 96 OX 112 abc 128 First Name FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST_NAME FIRST NAME FIRST_NAME Last Name LAST_NAME LAST_NAME LAST_NAME LAST_NAME LAST_NAME LAST_NAME LAST NAME LAST_NAME LAST_NAME LAST_NAME EMAIL EMAIL EMAIL Phone Number PHONE NUMBER PHONE_NUMBER PHONE NUMBER PHONE NUMBER PHONE_NUMBER PHONE NUMBER PHONE NUMBER PHONE_NUMBER PHONE_NUMBER PHONE_NUMBER Hire Date HIRE DATE HIRE_DATE HIRE_DATE HIRE DATE HIRE DATE HIRE DATE HIRE DATE HIRE_DATE HIRE DATE HIRE_DATE Job Id Salary Commission Pct Manager IdDepartment Id JOB SALA COM MAN DEPA JOB I SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB SALA COM MAN DEPA JOB I SALA COM MAN DEPA JOB I SALA COM MAN DEPA JOB SALA COM MAN DEPA ZIK 144 OLE OCX 160 abc 176 TYZ + EMPLOYEE_ID EMPLOYEE ID EMPLOYEE_ID EMPLOYEE_ID EMAIL EMAIL EMAIL EMAIL 208 224 240 T 256 272 288 304 Q 1x 2.25 1 193.50 Is canvas raised if user navigates to an item that is hidden by another ca Mod: DEPT_EMP File: 1 Assignment DBMSV43\DEPT_EMP.fmb j Type here to search mm x] 01:57 AM 17/05/2020 131 - x x Block: ? 8 $8: Oracle Forms Builder - D:\Courses_Sem1_2017-'18\441DBMS\441 Assignment DBMS\A3\DEPT_EMP.fmb File Edit View Navigator Program Tools Window Help Object Navigator 0 x DEPT_EMP: CANVASZ (DEPARTMENTS) WINDOW1 Find: DOU OZK Canvas: CANVASZ 2- Forms -DEPT_EMP T Segoe UI BIU Triggers Alerts 4 116 13: 195 Attached Libraries DEPARTMENTS EMPLOYEES + Data Blocks Canvases 82 CANVAS Tab Pages DEPARTMEN DEPARTMENTS Graphics DEPARTMENT_NAME O FRAME4 gerid MANAGER_ID IMAGE11 LOLION LOCATION || -EMPLOYEES -Editors O-LOVS Object Groups -Parameters Call Chart: EMP_ENAME SALARY Call Report: EMP_DEPT_JOB Popup Menus Program Units .- Property Classes -Record Groups 2.88 - Reports Visual Attributes Windows O WINDOW1 0 Menus O-PL/SQL Libraries -Object Libraries Built-in Packages # Database Objects Q 1x 267.75 226.50 COOHO00 GOLO 60X E100 Call Form: JOB_HISTORY Title to be displayed for the object. Mod: DEPT_EMP File: 1 Assignment DBMSV43\DEPT_EMP.fmb Type here to search xo 01:57 AM 17/05/2020 131 - x Canvas: CANVAS Canvas: CANVAS P -Triggers Canvases Oracle Forms Builder - D:\Courses_Sem1_2017-'18\441DBMS\441 Assignment DBMS\A3VOB_HISTORY.fmb File Edit View Format Arrange Program Tools Window Help Object Navigator O x 9 DEPT_EMP: CANVASZ (DEPARTMENTS) x CANVASZ Find: DOO Block: DEPARTMENTS ? Popup Menus T Segoe UI 9 BIU 3 i Ht yli 1 P Program Units Property Classes 13 116 132 148 164 180196 1112,128 144/160/176|1922081224/240256|272/2883041320 336|352|368 384 400 416/432/4481464/480 496/512528544560576592114 -Record Groups JOB_HISTORY: CANVAS (JOB_HISTORY) ox Reports - Visual Attributes DO X Block: JOB_HISTORY ? . Windows WINDOW1 T Segoe UI 9 BIU i Htuli JOB_HISTORY 0 16 132 148 164 80 96 112,128144160176 192 304 320 336352 368 384 400 416432448 464 480 496512528544560 Alerts - Attached Libraries + Data Blocks Employeeld Start Date End Date Job ld Department Id EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN Editor's EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN LOV EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN EMPLOYEE_ID START_DATE END_DATE JOB_ID - Parameters DEPARTMEN Popup Menus X 112 EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN Program Units o abc 128 EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN Property Classes 144 EMPLOYEE ID START_DATE END_DATE JOB ID DEPARTMEN - Record Groups 160 EMPLOYEE_ID START_DATE END DATE JOB_ID DEPARTMEN Reports 0- Visual Attributes abc 176 EMPLOYEE_ID START_DATE END DATE JOB_ID DEPARTMEN # Windows EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN Menus E DEPT_EMP_MENU EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMEN - Attached Libraries Menus MENU1 Items LT FILE CANVAS2 O-LOVS Object Groups Q 1x 0.00 19 0.00 Mod: JOB_HISTORY File: ssignment DBMSVAGWOB_HISTORY.fmb Type here to search WILL 01:59 AM 17/05/2020 731 - x Block Oracle Forms Builder - DA Courses_Sem1_2017-'181441DBMS 441 Assignment DBMS\A3\DEPT_EMP_MENU.mmb File Edit Menu Program Tools Window Help Object Navigator O x I DEPT_EMP: CANVASZ (DEPARTMENTS x DATA Find: DOO Canvas: CANVAS ? Iriggers T Segoe UI BIU P 0-Alerts -Attached Libraries 116 132 48 64 80 96 1127128144160 176192 2081224/240256|272289304|320336352 368 384 400 416 432448464480 4965125285445605765921 # Data Blocks Canvases 16 CANVASZ DEPT_EMP_MENU: Menu Editor O O IX Tab Pages Display Menu: MENU1 TE 6-DEPARTMENTS .- Graphics File A Record Data A OFRAME4 Execute Query IMAGE11 First Record Call Chart: EMP_ENAME_SALARY #-EMPLOYEES Enter Query Previous Record Call Report: EMP_DEPT_JOB -Editors Exit Next Record Call Form: JOB_HISTORY -Object Groups Last Record .- Parameters "Popup Menus "Program Units -Property Classes -Record Groups -Reports Visual Attributes Windows CE O WINDOW1 Menus E DEPT_EMP_MENU -Attached Libraries Menus MENU1 Items FILE Q 1x 122.25 0.75 U RECORD DATA E DATA O-LOVS Mod: DEPT_EMP_MENU File: ignment DBMSV3 DEPT_EMP_MENU.mmb Type here to search o jj xo 01:58 AM 17/05/2020 131