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
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...
Related questions
Question

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images

Recommended textbooks for you

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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning

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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science

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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education

Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY