Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Retrieve the names of projects that Joyce English is working on. Find the total number of projects that Franklin Wong is working on. Find the
- Retrieve the names of projects that Joyce English is working on.
- Find the total number of projects that Franklin Wong is working on.
- Find the names of employees that work on the project Computerization.
- For the departments located in Houston, list their manager names.
- For the projects located in Stafford, list the names of employees who are working on them
EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber 444 Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation L PROJECT | Pname Pnumber Plocation | Dnum WORKS_ON Essn Pno Hours DEPENDENT Essn | Dependent_name Sex Bdate Relationship Figure 3.7 Referential integrity constraints displayed on the COMPANY relational database schema. EMPLOYEE Frame Minit John B Franklin T Alicia Jennifer S Ramesh K Joyce A Ahmad V James E name San Bdate Address Sex Salary Super_san Dno Smith 1234567891965-01-09 731 Fondren, Houston, TXM 30000 333445500 5 Wong 333445500 1956-12-08 638 Voss, Houston, TX M 40000 888666000 Zelaya 999887777 1968-01-19 3321 Castle, Spring. TXF 25000 987654321 Wallace 9876543211941-06-20 291 Berry, Bellaire, TX F 43000 888660000 4 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445500 English 453453453 1972-07-31 5631 Rice, Houston, TXF 25000 3334450055 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TXM 25000 987654321 Borg 888666560 1937-11-10450 Stone, Houston, TX M 60000 NULL DEPT LOCATIONS Dnumber Dlocation DEPARTMENT Drame Research Administration Headquarters Houston Dnumber 5 4 1 Mar ss 3 33445566 987654321 8 88666560 1 Mar start date 1988-05-22 1 995-01-01 1981-06-19 Stafford Bellaire Sugarland Houston WORKS ON Pnumber Plocation Dnum Hours 32.5 7.5 1 2 Ess Pro 1234567891 1234567892 6668844443 4534534531 4534534532 PROJECT Prame ProductX ProductY Productz Computerization Reorganization Newbenefits 40.0 20.0 20.0 10.0 100 3 10 20 30 Bellaire Sugarland Houston Stafford ouston Stafford H 333445555 10 10.0 20 10.0 Sex DEPENDENT Essn 333445660 333445059 30.0 10.0 Dependent_name Alice Theodore 10 333445005 333445005 333445005 999887777 999887777 987987987 987987987 987654321 987654321 888665050 333445855 Joy 10 30 30.0 50 Bdate 1986-04-05 1983-10-25 1968-06-03 1942-02-28 1988-01-04 1988-12-30 1967-05-00 Relationship Daughter Son Spouse Spouse Son Daughter Spouse 987654321 Abner 200 30 20 20 123456789 123456789 123456789 Michael Alice Elizabeth F F NULL
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started