Given the following Relations in a DBMS write the output of the queries, in tuple form with attribute labels. EMPLOYEE Sox Salary Supor_ssn Dno Minit Lnamo B Smith 123456780 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 Wong 333445555 1055-12-08 638 Voss, Houston, TX Zolaya 000887777 | 1068-01-10 3321 Castlo, Spring, TX Wallace 087654321 1941-06-20 201 Borry, Bollairo, TX Narayan 666884444 1062-00-15 075 Firo Oak, Humblo, TXM English 453453453 1972-07-31 5631 Rice, Houston, TX Fname San Bdato Addross John 40000 888665555 25000 087654321 Franklin M. Alicia F 4 Jennifor 43000 888665555 Ramesh K 38000 333445555 Joyce A 25000 333445555 087987987 1069-03-20 080 Dallas, Houston, TX 888665555 1937-11-10 450 Stone, Houston, TX Ahmad Jabbar M 25000 087654321 4 E Borg 55000 NULL Jamos M 1 DEPARTMENT DEPT_LOCATIONS Dnumber Dnamo Rosoarch Administration Mgr_san Mgr_start_dato Dnumber Dlocation 333445555 1088-05-22 Houston 4 087654321 1005-01-01 4 Stafford Headquarters 888665555 1981-06-10 5 Bellaire PROJECT Sugarland Pnumber Pname ProductX Plocation Bollaire Dnum Houston 5 ProductY 2 Sugarland Productz Houston Computerization Rorganization Nowbenefits 10 Stafford 4 20 Houston 30 Stafford 4 Query 1: SELECT Pnumber, Dnum, Lname, Address, Bdate FROM PROJECT, DEPARTMENT, EMPLOYEE WHERE Dnum=Dnumber AND Mgr_ssn=Ssn AND Plocation='Stafford' Query 2: SELECT E.Fname, E.Lname, S.Fname, S.Lname FROM EMPLOYEE AS E, EMPLOΥΕ Ε AS S WHERE E.Super_ssn=S.Ssn

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Given the following Relations in a DBMS write the output of the queries, in tuple form with
attribute labels.
EMPLOYEE
Sex Salary Super_ssn Dno
123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555
Fname
Minit
Lname
Ssn
Bdate
Address
John
в
Smith
Franklin T
333445555 1955-12-08 638 Voss, Houston, TX
999887777 1968-01-19 3321 Castle, Spring, TX
Wallace 987654321 1941-06-20 291 Borry, Bollaire, TX
Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M
English 453453453 1972-07-31 5631 Rice, Houston, TX
40000 888665555
25000 987654321
43000 888665555
Wong
M
Alicia
Zelaya
Jennifer
F
4
Ramesh
K
38000 333445555
Joyce
A
F
25000 333445555
Ahmad
V
Jabbar
987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321
4
E Borg
55000 NULL
James
888665555 1937-11-10 450 Stone, Houston, TX
M
1
DEPARTMENT
DEPT_LOCATIONS
Dnumber
Mgr_ssn
Dname
Rosearch
Mgr_start_date
Dlocation
Dnumber
333445555
1988-05-22
Houston
Administration
4
987654321
1995-01-01
4
Stafford
Headquarters
1
888665555
1981-06-19
5
Bellaire
PROJECT
Sugarland
Pname
Pnumber
Plocation
Dnum
5
Houston
ProductX
Bellaire
5
ProductY
2
Sugarland
5
Productz
3
Houston
5
Computerization
10
Stafford
4
Reorganization
20
Houston
Newbenefits
30
Stafford
Query 1: SELECT
Pnumber, Dnum, Lname, Address, Bdate
FROM
PROJECT, DEPARTMENT, EMPLOYEE
WHERE
Dnum=Dnumber AND Mgr_ssn=Ssn AND Plocation='Stafford'
Query 2: SELECT
E.Fname, E.Lname, S.Fname, S.Lname
FROM
EMPLOYEE AS E, EMPLOYEE ASs
WHERE
E.Super_ssn=S.Ssn
Transcribed Image Text:Given the following Relations in a DBMS write the output of the queries, in tuple form with attribute labels. EMPLOYEE Sex Salary Super_ssn Dno 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Fname Minit Lname Ssn Bdate Address John в Smith Franklin T 333445555 1955-12-08 638 Voss, Houston, TX 999887777 1968-01-19 3321 Castle, Spring, TX Wallace 987654321 1941-06-20 291 Borry, Bollaire, TX Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M English 453453453 1972-07-31 5631 Rice, Houston, TX 40000 888665555 25000 987654321 43000 888665555 Wong M Alicia Zelaya Jennifer F 4 Ramesh K 38000 333445555 Joyce A F 25000 333445555 Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 4 E Borg 55000 NULL James 888665555 1937-11-10 450 Stone, Houston, TX M 1 DEPARTMENT DEPT_LOCATIONS Dnumber Mgr_ssn Dname Rosearch Mgr_start_date Dlocation Dnumber 333445555 1988-05-22 Houston Administration 4 987654321 1995-01-01 4 Stafford Headquarters 1 888665555 1981-06-19 5 Bellaire PROJECT Sugarland Pname Pnumber Plocation Dnum 5 Houston ProductX Bellaire 5 ProductY 2 Sugarland 5 Productz 3 Houston 5 Computerization 10 Stafford 4 Reorganization 20 Houston Newbenefits 30 Stafford Query 1: SELECT Pnumber, Dnum, Lname, Address, Bdate FROM PROJECT, DEPARTMENT, EMPLOYEE WHERE Dnum=Dnumber AND Mgr_ssn=Ssn AND Plocation='Stafford' Query 2: SELECT E.Fname, E.Lname, S.Fname, S.Lname FROM EMPLOYEE AS E, EMPLOYEE ASs WHERE E.Super_ssn=S.Ssn
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY