Answered step by step
Verified Expert Solution
Link Copied!

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

  1. Retrieve the names of projects that Joyce English is working on.
  2. Find the total number of projects that Franklin Wong is working on.
  3. Find the names of employees that work on the project Computerization.
  4. For the departments located in Houston, list their manager names.
  5. For the projects located in Stafford, list the names of employees who are working on them

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions