Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  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

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_2

Step: 3

blur-text-image_3

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 Thermodynamics

Authors: Richard E. Sonntag, Claus Borgnakke, Gordon J. Van Wylen

6th edition

471152323, 978-0471152323

More Books

Students also viewed these Databases questions

Question

Understand the content theories of motivation.

Answered: 1 week ago