Consider the following two tables. Tablel: Course CourseID ITDR2104 Title Credit Programming Ethical Hacking Cyber Security Computer Graphics Operating Systems ITSY4114 3 ITSY4111 ITSW4111 ITDR3102 Table2: Student studentID Fname Lname CourseID 1001 1002 1003 Fatma Al Kalbani ITDR2104 Laila Al Mukheini ITDR2104 ITSY4111 Hager Nada Al Harthi 1004 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): 1. SELECT S.Fname, SLname, 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; 3. SELECT S.Fname, SLname, C.Title FROM Course AS C RIGHT OUTER JOIN Student AS S ON C.CourselD = S.CourselD;

Consider the following two tables. Tablel: Course CourseID ITDR2104 Title Credit Programming Ethical Hacking Cyber Security Computer Graphics Operating Systems ITSY4114 3 ITSY4111 ITSW4111 ITDR3102 Table2: Student studentID Fname Lname CourseID 1001 1002 1003 Fatma Al Kalbani ITDR2104 Laila Al Mukheini ITDR2104 ITSY4111 Hager Nada Al Harthi 1004 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): 1. SELECT S.Fname, SLname, 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; 3. SELECT S.Fname, SLname, 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

See similar textbooks

Similar questions

please choose the most correct anwser.
What is the procedure through which SaaS functions? Could you please explain what you mean?
What is OLAP?
What is OLAP?
please answer the two questions under the second image. Also please include how you knew it was the foreign and primary key
Label each phrase as either interpretation sharing, projection sharing, or fact sharing. Note: each information sharing type is used once. Diesel is leaking from the ship onto the dock. Answer (circle one): interpretation sharing, projection sharing, fact sharing. There is a fire station near the diesel leak. Those firefighters have been trained to respond to small diesel spills. Answer (circle one): interpretation sharing, projection sharing, fact sharing. If the ship leaks more than 10,000 gallons of diesel, then we will need to send in additional firefighters and specialized equipment trucks through Route B. Answer (circle one): interpretation sharing, projection sharing, fact sharing.
Look at how the main key-based definitions of 2NF and 3NF are different from the general definitions of 2NF and 3NF. Give a detailed example to back up your answer.
Note:- Put the answer if you are 100% sure of the answer, otherwise no Q1 : pictures Q2:pictures
I need the answer as soon as possible
What is OLAP?
Does this ERD make any sense? Does it have 1NF, 2NF and 3NF? Business Rules Teacher:Teacher can teach one or more classes.Teacher checks attendances and each attendedance record belongs to a teacher of that class.Teacher may or may not contact parents of student. Parent:Parent can enroll at least one student.parent may or may not be contacted by teacher.parent can contact any teacher in the school. Student:Students must take at least classesEach student can only have one primary contact parent.An attendance keeps track of students. School:School assignes classes.Classes are assigned by a school Class:A class must be taken by at least one student.More than one classes can be taught by a teacher.Classes are assigned by a school. Attendance:Attendances are checked by a teacher to keep record of students.Student take attendances.attendance keeps track of each student.
Suppose you are a judge trying to decide a dispute between a buyer and a supplier. The buyer claims not to have produced a particular email purchase order, while the supplier shows you the purchase order, and certificates and CRLs (Certificate Revocation Lists), demonstrating that the purchase order was signed by the buyer. All documents have been signed by a notary. How would the dates on the various pieces of evidence influence your decision? What if only the purchase order was signed by the notary?