II. Synthesis: Analyze the given case and answer the following question accordingly. 03. 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 ProfessorID P8259 P8261 P8444 P8263 Table2 COURSE CourselD COMP511 COMP621 COMPS32 COMP542 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 Professor D 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 ProfessorD-FACULTY ProfessorID AND Professor P8259 OR ProfessoriD-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
1.
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
COMPS32
COMP542
ProfessorName
COMP553
COMP564
Will
Joy
CourselD
CourseName
COMPS11 Compute Fundamentals
COMP621 Web Technologies
Charles
Andres
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
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
Professor D-P8259 OR ProfessoriD-P8263
Transcribed Image Text:1. 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 COMPS32 COMP542 ProfessorName COMP553 COMP564 Will Joy CourselD CourseName COMPS11 Compute Fundamentals COMP621 Web Technologies Charles Andres 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 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 Professor D-P8259 OR ProfessoriD-P8263
Expert Solution
steps

Step by step

Solved in 3 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