Consider the relational database described in Tables 1- 4.

Implement the following stored procedures in PL/SQL

A. Create for a company X the following report (shown below for Facebook):

Company Name:Facebook

Located in: Silicon Valley

Total Employees: 5

Total Managers: 2

Average Salary Employees: 322800

Average Salary Managers: 550000

Test and include in the assignment the report for General Electric and Oracle (before modifying salary values in the second store procedure).

B. Give all employees that works in a company located in city X a Y percent raise if they are managers and Z percent raise if they are not managers. X, Y, and Z will be the three parameters for the stored procedure. Test your procedure, and show that it worked correctly (using SQL statements before and after update).

Table 1: Employee Employee name William Gates IlI Warren Buffett Lakshmi Mittal Carlos Slim Helu Prince Gatlin Ingvar Kamprad Paul Allen Karl Albrecht Lawrence Ellison Mark Zuckerber Sheryl Sandber Dave Wehner Mike Schroepfer Chris Cox Kenneth Thomson Liliane Bettencourt Bernard Arnault Michael Dell Sheldon Adelson Theo Albrecht Street University St Alaskan Way 1st Ave 1st Ave 2nd Ave University Ave First St Westlake Ave 20717 International Blvd First Avenue Second Avenue Third Avenue Fourth Avenue Sixth Avenue 20717 International Blvd 21 Rue de Miroir 18 Avenue de Suffren 4533 South 4533 South Westlake Ave City Redmond Omaha London London Birmingham Oslo Seattle London Silicon Valle Silicon Vall Silicon Vall Silicon Vall Silicon Valley Silicon Valley Silicon Valley Lyon Paris Austin Austin London Table 1: Employee Employee name William Gates IlI Warren Buffett Lakshmi Mittal Carlos Slim Helu Prince Gatlin Ingvar Kamprad Paul Allen Karl Albrecht Lawrence Ellison Mark Zuckerber Sheryl Sandber Dave Wehner Mike Schroepfer Chris Cox Kenneth Thomson Liliane Bettencourt Bernard Arnault Michael Dell Sheldon Adelson Theo Albrecht Street University St Alaskan Way 1st Ave 1st Ave 2nd Ave University Ave First St Westlake Ave 20717 International Blvd First Avenue Second Avenue Third Avenue Fourth Avenue Sixth Avenue 20717 International Blvd 21 Rue de Miroir 18 Avenue de Suffren 4533 South 4533 South Westlake Ave City Redmond Omaha London London Birmingham Oslo Seattle London Silicon Valle Silicon Vall Silicon Vall Silicon Vall Silicon Valley Silicon Valley Silicon Valley Lyon Paris Austin Austin London