nen upload it): SELECT S.Fname, S.Lname, C.Title FROM Course AS C INNER JOIN Student AS S ON C.CourselD = S.CourselD; SELECT S.Fname, S.Lname, C.Title FROM Course AS C LEFT OUTER JOIN Student AS S ON C.CourselD = S.CourselD; SELECT S.Fname, S.Lname, C.Title FROM Course AS C RIGHT OUTER JOIN Student AS S ON C.CourselD = S.CourselD;

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
icon
Related questions
Question
Tablel: Course
CourselD
Title
Credit
Programming
Ethical Hacking
ITDR2104
3
ITSY4114
3
Cyber Security
Computer Graphics
Operating Systems
ITSY4111
3
ITSW4111
3
ITDR3102
Table2: Student
studentID Fname
3
Lname
CourseID
1001
Fatma
Al Kalbani
ITDR2104
1002
Laila
Al Mukheini
ITDR2104
1003
Hager
Al Harthi
ITSY4111
1004
Nada
Al Badi
ITSY4111
1005
Manar
Al Mazidi
ITSW4111
1006
Salim
Alsaadi
ITDR2106
Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document
word then upload it):
Transcribed Image Text:Tablel: Course CourselD Title Credit Programming Ethical Hacking ITDR2104 3 ITSY4114 3 Cyber Security Computer Graphics Operating Systems ITSY4111 3 ITSW4111 3 ITDR3102 Table2: Student studentID Fname 3 Lname CourseID 1001 Fatma Al Kalbani ITDR2104 1002 Laila Al Mukheini ITDR2104 1003 Hager Al Harthi ITSY4111 1004 Nada Al Badi ITSY4111 1005 Manar Al Mazidi ITSW4111 1006 Salim Alsaadi ITDR2106 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it):
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 S.Fname, S.Lname, C.Title
FROM Course AS C
INNER JOIN Student AS S
ON C.CourselD =S.CourselD;
2.
SELECT S.Fname, S.Lname, C.Title
FROM Course AS C
LEFT OUTER JOIN Student AS S
ON C.CourselD =S.CourselD;
3.
SELECT S.Fname, S.Lname, C.Title
FROM Course AS C
RIGHT OUTER JOIN Student AS S
ON C.CourselD = S.CourselD;
Transcribed Image Text: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 S.Fname, S.Lname, C.Title FROM Course AS C INNER JOIN Student AS S ON C.CourselD =S.CourselD; 2. SELECT S.Fname, S.Lname, C.Title FROM Course AS C LEFT OUTER JOIN Student AS S ON C.CourselD =S.CourselD; 3. SELECT S.Fname, S.Lname, C.Title FROM Course AS C RIGHT OUTER JOIN Student AS S ON C.CourselD = S.CourselD;
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Table
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education