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).

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