Answered step by step
Verified Expert Solution
Link Copied!

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***

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OCA Oracle Database SQL Exam Guide Exam 1Z0-071

Authors: Steve O'Hearn

1st Edition

1259585492, 978-1259585494

More Books

Students also viewed these Databases questions

Question

What is nonverbal communication?

Answered: 1 week ago