can result by executing Tollowing SQL statements nswer in 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; Attach File Browse My Computer

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
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 ASC
LEFT OUTER JOIN Student AS S
ON C.CourselID = S.CourselD;
3.
SELECT S.Fname, S.Lname, C.Title
FROM Course ASC
RIGHT OUTER JOIN Student AS S
ON C.CourselD = S.CourselD;
Attach File
Browse My Computer
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 ASC LEFT OUTER JOIN Student AS S ON C.CourselID = S.CourselD; 3. SELECT S.Fname, S.Lname, C.Title FROM Course ASC RIGHT OUTER JOIN Student AS S ON C.CourselD = S.CourselD; Attach File Browse My Computer
QUESTION 10
Consider the following two tables.
Tablel: Course
CourselD
Title
Credit
ITDR2104
Programming
3
ITSY4114
Ethical Hacking
3
ITSY4111
Cyber Security
Computer Graphics
Operating Systems
ITSW4111
3
ITDR3102
3
Table2: Student
studentID
Fname
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
Transcribed Image Text:QUESTION 10 Consider the following two tables. Tablel: Course CourselD Title Credit ITDR2104 Programming 3 ITSY4114 Ethical Hacking 3 ITSY4111 Cyber Security Computer Graphics Operating Systems ITSW4111 3 ITDR3102 3 Table2: Student studentID Fname 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
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Intermediate SQL concepts
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