USE SQL CODE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! NOT RELATIONAL ALGEBRAA!!!!!!!!!!! 1. Retrieve nam
Posted: Fri Jul 01, 2022 5:34 am
USE SQLCODE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! NOTRELATIONAL ALGEBRAA!!!!!!!!!!!
1. Retrieve name and salary of all male employees who havedependents
2. Retrieve name of all department managers
3. Retrieve names of project controlled by ‘ResearchDepartment’
4. Find the names and addresses of employees who work on aproject located in Stafford.
5. Insert a new project “ProductO”, with pnumber 4, located atHouston, controlled by
department 4
6. Update Project location as Sugerland for project 4
EMPLOYEE FNAME MINIT LNAME SSN B Smith 123456789 T Wong 333445555 J Zelaya 999887777 S Wallace 987654321 666884444 K A V E Borg DEPARTMENT WORKS ON John Franklin Alicia Jennifer Ramesh Joyce Ahmad James DEPENDENT DNAME Research Administration Headquarters 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 ..... 999887777 987987987 987987987 987654321 987654321 888665555 ESSN PNO HOURS 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 ESSN 333445555 333445555 333445555 987654321 123456789 123456789 123456789 1 2 3 1 2 2 10 288228888 20 30 10 Narayan English Jabbar 10 30 30 20 20 BDATE 1965-01-09 1955-12-08 1968-07-19 1941-06-20 1962-09-15 1972-07-31 987987987 1969-03-29 888665555 1937-11-10 453453453 DNUMBER 5 4 1 10.0 35.0 5.0 20.0 15.0 null MGRSSN 333445555 Alice Theodore Joy Abner Michael Alice Elizabeth 987654321 888665555 PROJECT DEPENDENT_NAME SEX BDATE M F 1986-04-05 1963-10-25 F 1958-05-03 1942-02-28 1988-01-04 M M F F ADDRESS 731 Fondren, Houston, TX 638 Voss, Houston, TX 3321 Castle, Spring, TX 291 Berry, Bellaire, TX 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dallas, Houston, TX 450 Stone, Houston, TX MGRSTARTDATE 1988-05-22 1995-01-01 1981-06-19 1968-12-30 1967-05-05 DEPT_LOCATIONS PNAME ProductX ProductY ProductZ Computerization Reorganization Newbenefits SEX SALARY M M F 30000 40000 25000 43000 38000 25000 25000 55000 RELATIONSHIP DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE F M F M M 3 DNUMBER 1 4 10 20 5 5 5 SUPERSSN DNO 333445555 5 888665555 5 987654321 4 888665555 4 333445556 5 333445555 5 987654321 4 null 1 PNUMBER PLOCATION 1 2 DLOCATION Houston Stafford Bellaire Sugarland Houston Bellaire Sugarland Houston Stafford Houston Stafford DNUM 5 5 5 4 1 4
- Use Sql Code Not Relational Algebraa 1 Retrieve Nam 1 (216.48 KiB) Viewed 42 times
2. Retrieve name of all department managers
3. Retrieve names of project controlled by ‘ResearchDepartment’
4. Find the names and addresses of employees who work on aproject located in Stafford.
5. Insert a new project “ProductO”, with pnumber 4, located atHouston, controlled by
department 4
6. Update Project location as Sugerland for project 4
EMPLOYEE FNAME MINIT LNAME SSN B Smith 123456789 T Wong 333445555 J Zelaya 999887777 S Wallace 987654321 666884444 K A V E Borg DEPARTMENT WORKS ON John Franklin Alicia Jennifer Ramesh Joyce Ahmad James DEPENDENT DNAME Research Administration Headquarters 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 ..... 999887777 987987987 987987987 987654321 987654321 888665555 ESSN PNO HOURS 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 ESSN 333445555 333445555 333445555 987654321 123456789 123456789 123456789 1 2 3 1 2 2 10 288228888 20 30 10 Narayan English Jabbar 10 30 30 20 20 BDATE 1965-01-09 1955-12-08 1968-07-19 1941-06-20 1962-09-15 1972-07-31 987987987 1969-03-29 888665555 1937-11-10 453453453 DNUMBER 5 4 1 10.0 35.0 5.0 20.0 15.0 null MGRSSN 333445555 Alice Theodore Joy Abner Michael Alice Elizabeth 987654321 888665555 PROJECT DEPENDENT_NAME SEX BDATE M F 1986-04-05 1963-10-25 F 1958-05-03 1942-02-28 1988-01-04 M M F F ADDRESS 731 Fondren, Houston, TX 638 Voss, Houston, TX 3321 Castle, Spring, TX 291 Berry, Bellaire, TX 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dallas, Houston, TX 450 Stone, Houston, TX MGRSTARTDATE 1988-05-22 1995-01-01 1981-06-19 1968-12-30 1967-05-05 DEPT_LOCATIONS PNAME ProductX ProductY ProductZ Computerization Reorganization Newbenefits SEX SALARY M M F 30000 40000 25000 43000 38000 25000 25000 55000 RELATIONSHIP DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE F M F M M 3 DNUMBER 1 4 10 20 5 5 5 SUPERSSN DNO 333445555 5 888665555 5 987654321 4 888665555 4 333445556 5 333445555 5 987654321 4 null 1 PNUMBER PLOCATION 1 2 DLOCATION Houston Stafford Bellaire Sugarland Houston Bellaire Sugarland Houston Stafford Houston Stafford DNUM 5 5 5 4 1 4