1. make a stored procedure called projects_at_this_location that receives a location and returns the projects (if any) at that location as shown in the following sample run: (2 points)

     exec projects_at_this_location('Stafford');

            Projects at This Location

       =======================

  Computerization

              Newbenefits

 

This is the schema pls help the instructor wants the answers original, using SQL

EMPLOYEE Fname Minit Lname Ssn Bdate Address John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX James E Borg 888665555 1937-11-10 450 Stone, Houston, TX DEPARTMENT Dname Research Administration Headquarters WORKS ON Essn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Dnumber 5 4 1 Pno 1 2 3 1 2 2 3 10 20 30 10 10 30 30 20 20 Figure 5.6 One possible database state for the COMPANY relational database schema. Hours 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 20.0 15.0 NULL Mgr_ssn 333445555 987654321 888665555 DEPENDENT Essn 333445555 333445555 333445555 987654321 123456789 123456789 123456789 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 PROJECT Alice Pname ProductX ProductY ProductZ Computerization Reorganization Newbenefits Theodore Joy Abner Michael Alice Elizabeth Super_ssn Dno 30000 333445555 40000 888665555 25000 987654321 4 43000 888665555 4 M 38000 333445555 25000 333445555 25000 987654321 4 M 55000 NULL 1 F M Dependent_name Sex F M F M M F F Sex Salary M M F F DEPT_LOCATIONS Dnumber 1 4 5 5 5 Pnumber 1 2 3 10 20 30 Plocation Bellaire Sugarland Houston Stafford Houston Stafford 50 50 50 50 Dlocation Houston Stafford Bellaire Sugarland Houston Dnum 5 5 5 4 1 4 Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 1988-12-30 Daughter 1967-05-05 Spouse