Answered step by step
Verified Expert Solution
Question
1 Approved Answer
***PLEASE PROVIDE SCREEN SHOT FROM TEXT EDITOR TO BE ABLE FOR LEGIBILITY*** Processing and Updating a Group of Rows To help track employee information, a
***PLEASE PROVIDE SCREEN SHOT FROM TEXT EDITOR TO BE ABLE FOR LEGIBILITY***
Processing and Updating a Group of Rows To help track employee information, a new EMPLOYEE table was added to the Brewbean's database. Review the data in this table. A PL/SOL block is needed to calculate annual raises and update employee salary amounts in the table. Create a block that addresses all the requirements in the following list. Al salaries in the EMPLOYEE table are recorded as monthly amounts. Tip: Display the calculated salaries for verification before including the update action . Calculate 6% annual raises for all employees except the president. If a 6% raise totals more than S2,000, cap the raise at S2,OOO. Update the salary for each employee in the table. For each employee number, display the current annual salary, raise, and proposed new annual salary Finally, following the details for each employee, show the total cost of all employees' salary increases for Brewbean's Also the schema for Employee table Name Null? Type EMPNO NOT NULL NUMBER(4) ENAME VARCHAR210) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) Connections xlL Reports x +R27 Connections XE_plbook ables (Filtered) B- BB-AUDIT-LOGON BB-BASKET B- BBBASKETITEM B-BBBASKETSTATUS BB BLOCKTEST - BBDEPARTMENT - BB PROD-SALES B- BB-PRODUCT BB-PRODUCT REQUEST BB.PRODUCTOPTION BB-PRODUCTOPTIONCATEGORY BB-PRODUCTOPTION DETAIL BB.PROMO B. BB-PROMOLIST B- BB-SHIPPING . BBSHOPSALES - - B-| BB-SHOPPER BB-TRANS-LOG Processing and Updating a Group of Rows To help track employee information, a new EMPLOYEE table was added to the Brewbean's database. Review the data in this table. A PL/SOL block is needed to calculate annual raises and update employee salary amounts in the table. Create a block that addresses all the requirements in the following list. Al salaries in the EMPLOYEE table are recorded as monthly amounts. Tip: Display the calculated salaries for verification before including the update action . Calculate 6% annual raises for all employees except the president. If a 6% raise totals more than S2,000, cap the raise at S2,OOO. Update the salary for each employee in the table. For each employee number, display the current annual salary, raise, and proposed new annual salary Finally, following the details for each employee, show the total cost of all employees' salary increases for Brewbean's Also the schema for Employee table Name Null? Type EMPNO NOT NULL NUMBER(4) ENAME VARCHAR210) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) Connections xlL Reports x +R27 Connections XE_plbook ables (Filtered) B- BB-AUDIT-LOGON BB-BASKET B- BBBASKETITEM B-BBBASKETSTATUS BB BLOCKTEST - BBDEPARTMENT - BB PROD-SALES B- BB-PRODUCT BB-PRODUCT REQUEST BB.PRODUCTOPTION BB-PRODUCTOPTIONCATEGORY BB-PRODUCTOPTION DETAIL BB.PROMO B. BB-PROMOLIST B- BB-SHIPPING . BBSHOPSALES - - B-| BB-SHOPPER BB-TRANS-LOG
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started