Consider the following two tables: Tablel: Customers customerID Fname 100 101 Lname Amri Kalabani Harthi Alshukaili Rawas City salma@gmail.com Salalah Rami@hotmail.com Sohar Adnan@yahoo.com Sur Amro@gmail.com Bahla Maataz@gmail.com Salalah ZipCode 211 email Salma Rami 205 102 Adnan 201 103 Amro 208 104 Maatz 211 Table2: Orders orderID 1 amount customerID 234$ orderDate 07/04/2019 100 03/14/2020 78$ 103 3 05/23/2019 124$ 102 07/21/2018 25$ 104 6. 11/27/2019 14$ 102 7 12:07/2020 55$ 106 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
Consider the following two tables: Tablel: Customers customerID Fname 100 101 Lname Amri Kalabani Harthi Alshukaili Rawas City salma@gmail.com Salalah Rami@hotmail.com Sohar Adnan@yahoo.com Sur Amro@gmail.com Bahla Maataz@gmail.com Salalah ZipCode 211 email Salma Rami 205 102 Adnan 201 103 Amro 208 104 Maatz 211 Table2: Orders orderID 1 amount customerID 234$ orderDate 07/04/2019 100 03/14/2020 78$ 103 3 05/23/2019 124$ 102 07/21/2018 25$ 104 6. 11/27/2019 14$ 102 7 12:07/2020 55$ 106 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Transcribed Image Text:Consider the following two tables:
Tablel: Customers
customerID Fname
Lname
email
ZipCode
City
Salalah
salma@gmail.com
Rami@hotmail.com Sohar
Adnan@yahoo.com| Sur
Amro@gmail.com
Maataz@gmail.com Salalah
100
Salma
Amri
211
101
Rami
Kalabani
205
102
Adnan
Harthi
201
103
Amro
Alshukaili
Bahla
208
104
Maatz
Rawas
211
Table2: Orders
orderID
orderDate
amount customerID
1
07/04/2019
234$
100
2
03/14/2020
78$
103
3
05/23/2019
124S
102
5
07/21/2018
|25$
104
6
11/27/2019
14$
102
7
12/07/2020
55$
106
Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document
word then upload it).
1.
SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount
FROM Customers AS c
INNER JOIN Orders AS o
ON c. customerID = 0. customerID;
SELECT c. Fname, c Lname, c, email, 0.orderDate, o.amount
2.
FROM Customers AS c
LEFT OUTER JOIN Orders AS o
ON c. customerID = 0. customerID;
3.
SELECT c.Fname, c. Lname, c.email, o.orderDate, o.amount
FROM Customers AS c
RIGHT OUTER JOIN Orders AS o
ON c. customerID = 0. customerID;
||
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education