Given the two (2) tables below, determine the result of each of the four (4) types of join. Display only the vendor names and the item descriptions. Illustrate the tables on a clean sheet of paper. Take a photo of your answers then upload.

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
Instructions
Given the two (2) tables below, determine the result of each of the four (4) types of join. Display only the
vendor names and the item descriptions. Illustrate the tables on a clean sheet of paper. Take a photo of
your answers then upload.
VendorID
VendorName
Contact Num
V00001
Universal Robina Corporation
8633-7631
V00002 Liwayway Marketing Corporation
8844-8441
V00003
Monde Nissin
7759-7500
Table 1. Vendors
Item Desc
Jack n Jill Piattos
Jack n Jill Nova
Oishi Prawn Crackers
Regent Cheese Ring
Table 2. Items
ItemID
P000101
PO00102
PO01005
PO30007
VendorID
VOO
V00001
V00002
V00004
Transcribed Image Text:Instructions Given the two (2) tables below, determine the result of each of the four (4) types of join. Display only the vendor names and the item descriptions. Illustrate the tables on a clean sheet of paper. Take a photo of your answers then upload. VendorID VendorName Contact Num V00001 Universal Robina Corporation 8633-7631 V00002 Liwayway Marketing Corporation 8844-8441 V00003 Monde Nissin 7759-7500 Table 1. Vendors Item Desc Jack n Jill Piattos Jack n Jill Nova Oishi Prawn Crackers Regent Cheese Ring Table 2. Items ItemID P000101 PO00102 PO01005 PO30007 VendorID VOO V00001 V00002 V00004
Expert Solution
steps

Step by step

Solved in 2 steps with 4 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