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
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