Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a PL/SQL block that uses data in the company database to do the following tasks: 1) Retrieve information about an employee and print

Create a PL/SQL block that uses data in the company database to do the following tasks: 1) Retrieve 3) Reset the salary in the database back to the original (Also, use the "update table ... "command). Print 

Create a PL/SQL block that uses data in the company database to do the following tasks: 1) Retrieve information about an employee and print it as follow: Current Salary: Employee's SSN: Name: Department Number: Department Name: Manager's Name: Current Salary: The program should assign a value or prompt for employee's SSN (such as 123456789, 333445555, or 999887777). Department # 1 4 2) Update that employee's salary information in the database after the raise is calculated. The percentage of the raise is based on the department he/she works for. The following shows the percentage of raise for each department: 5 The SQL syntax for update is: 123456789 John B. Smith 5 Research Franklin Wong 30,000.00 Salary after the raise: Employee's SSN: Name: Department Number: Department Name: Manager's Name: Current Salary: UPDATE table name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition]; Print the new salary information. Thus, the updated information should look like this: % Raise 3 5 7 123456789 John B. Smith 5 Research Franklin Wong 32,100.00 3) Reset the salary in the database back to the original (Also, use the "update table ... "command). Print the salary information again. Thus the final information should look like this: Current Salary: Employee's SSN: Name: Department Number: Department Name: Manager's Name: Current Salary: 123456789 John B. Smith 5 Research Franklin Wong 30,000.00 Note: Do all of these steps in one program!

Step by Step Solution

3.37 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

The image you sent shows a diagram of a social media data warehouse A data warehouse is a central repository for all of the data that a social media c... 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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Shamkant Navathe

7th Edition

0133970779, 978-0133970777

More Books

Students also viewed these Databases questions

Question

What is PEAR? What is PEAR DB?

Answered: 1 week ago