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

Sub : Economics
Pls answer very fast.I ll upvote. Thank You

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.

4. SELECT CEILING(74.2);

5. SELECT SUBSTRING('08 Activity 1', 3, 6);

 

VendorID VendorName
v00001 Universal Robina Corporation
V00002 Liwayway Marketing Corporation
V00003
Monde Nissin
Table 1. Vendors
ItemID
PO00101
PO00102
PO01005
PO30007 Regent Cheese Ring
Table 2. Items
Item Desc
Jack n Jill Piattos
Jack n Jill Nova
Oishi Prawn Crackers
Contact Num
8633-7631
8844-8441
7759-7500
VendorID
V00001
V00001
V00002
V00004
Transcribed Image Text:VendorID VendorName v00001 Universal Robina Corporation V00002 Liwayway Marketing Corporation V00003 Monde Nissin Table 1. Vendors ItemID PO00101 PO00102 PO01005 PO30007 Regent Cheese Ring Table 2. Items Item Desc Jack n Jill Piattos Jack n Jill Nova Oishi Prawn Crackers Contact Num 8633-7631 8844-8441 7759-7500 VendorID V00001 V00001 V00002 V00004
Expert Solution
steps

Step by step

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