H Synthesis: Analyze the given case and answer the following question accordingly. Q3. Based on the given tables FACULTY, COURSE, Perform the PROJECT operation using SELECT and JOIN operations as given in the query to create a subset of data. Show the output in a table format Tablet: FACULTY Professor D P8259 P8261 P8444 P8263 Table2 COURSE ProfessorName Will Joy Charles Andres CourselD CourseName COMP511 Compute Fundamentals COMP621 COMP532 COMP542 COMP553 COMP564 Web Technologies IT Infrastructure Data Mining Professor Address 190, Blue Mountain 4567, Miller Street 2320, 7th Avenue | 173, Adams Boulevard Cloud Computing Web Applications Semester First Second Third Fourth Fifth Sixth ProfessorCity California New York Seattle Texas ProfessorID P8444 P8263 P8259 P8261 P8444 P8259 ZipCode 6789 4567 2334 3245 Query: SELECT FACULTY ProfessoriD, FACULTY ProfessorName, FACULTY Professor City, COURSE CourselD, COURSE CourseName FROM COURSE, FACULTY WHERE COURSE. ProfessoriD-FACULTY.ProfessorID AND ProfessoriD-P8259 OR Professor-P8263

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
II.
Synthesis: Analyze the given case and answer the following question accordingly.
Q3. Based on the given tables FACULTY, COURSE, Perform the PROJECT operation using SELECT and JOIN operations as given in the query to create a subset of data. Show the output in a table format
Table1:
FACULTY
Professor D
P8259
P8261
P8444
P8263
Table2
COURSE
CourselD
COMPS11
COMP621
COMP532
COMPS42
COMP553
COMP564
ProfessorName
Will
Joy
Charles
Andres
CourseName
Compute Fundamentals
Web Technologies
IT Infrastructure
Data Mining
Cloud Computing
Web Applications
Professor Address
190, Blue Mountain
4567, Miller Street
2320, 7th Avenue
173, Adams Boulevard
Semester
First
Second
Third
Fourth
Fifth
Sixth
ProfessorID
P8444
P8263
P8259
P8261
ProfessorCity
California
New York
Seattle
Texas
P8444
P8259
ZipCode
6789
4567
2334
3245
Query:
SELECT FACULTY.ProfessoriD, FACULTY ProfessorName, FACULTY Professor City, COURSE CourselD, COURSE CourseName FROM COURSE, FACULTY WHERE COURSE ProfessorID=FACULTY.ProfessorID AND
ProfessorID=P8259 OR ProfessoriD-P8263
Transcribed Image Text:II. Synthesis: Analyze the given case and answer the following question accordingly. Q3. Based on the given tables FACULTY, COURSE, Perform the PROJECT operation using SELECT and JOIN operations as given in the query to create a subset of data. Show the output in a table format Table1: FACULTY Professor D P8259 P8261 P8444 P8263 Table2 COURSE CourselD COMPS11 COMP621 COMP532 COMPS42 COMP553 COMP564 ProfessorName Will Joy Charles Andres CourseName Compute Fundamentals Web Technologies IT Infrastructure Data Mining Cloud Computing Web Applications Professor Address 190, Blue Mountain 4567, Miller Street 2320, 7th Avenue 173, Adams Boulevard Semester First Second Third Fourth Fifth Sixth ProfessorID P8444 P8263 P8259 P8261 ProfessorCity California New York Seattle Texas P8444 P8259 ZipCode 6789 4567 2334 3245 Query: SELECT FACULTY.ProfessoriD, FACULTY ProfessorName, FACULTY Professor City, COURSE CourselD, COURSE CourseName FROM COURSE, FACULTY WHERE COURSE ProfessorID=FACULTY.ProfessorID AND ProfessorID=P8259 OR ProfessoriD-P8263
Expert Solution
steps

Step by step

Solved in 3 steps with 1 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