Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following two tables Student SLID LastName First Name 1 Duke Mike 2 Lee Lary 3 Johnson John CourseID 1 2 Course CourseID 1

image text in transcribed
image text in transcribed
image text in transcribed
Consider the following two tables Student SLID LastName First Name 1 Duke Mike 2 Lee Lary 3 Johnson John CourseID 1 2 Course CourseID 1 2 CourseName Data & Info. Mgt Intro to Mgt SCM We want to write a query that shows the students' names and the courses they are taking. Which one is the correct answer? SELECT S.Firstname, S. Lastname, C.CourseName FROM Student S, Course C WHERE S.CourselD=C.CourselD; SELECT S.Firstname, S. Lastname, C.CourseName FROM Student S, Course CON S.CourselD-C.CourselD; SELECT S.Firstname, S. Lastname, C.CourseName FROM Student S JOIN Course C WHERE S.CourselD=C.CourselD; SELECT S.Firstname, S. Lastname, C.CourseName FROM Student S INNER JOIN Course C WHERE S.CourselD=C.CourselD: Given the following two sets of numbers, what is the difference of the first set of numbers minus the second set? 1.6, 98, 125, 126, 127, 250 1,9, 98, 127, 250, 255, 260, 261 09, 255, 260, 261 1,98, 127, 250 O 6, 125, 126 1.6,9.98, 125, 126, 127, 250, 255, 260, 261 onsider the following two tables. Student SUID 1 Course CourseID 1 Last Name Duke Lee Johnson FirstName Mike Lary John CourseID 1 2 2 CourseName Data & Info. Mgt Intro to Mgt SCM 2 3 What is the result of the following Query? SELECTS SUID, S.LastName, C.CourseName FROM Student AS SINNER JOIN Course AS CON S.Coursel - C.CourselD; SLID 1 2 LastName Duke Lee CourseName Data & info. Mgt Intro to Mgt SCM SUID 1 2 3 Last Name Duke Lee Johnson CourseName Intro. to Mgt Data & Info. Mgt SEID 1 2 LastName Duke Lee CourseName Data & Info. Mgt Intro to Mgt SLID 1 2 Last Name Duke Lee Course Name Intro to Mgt Data & Info. Mgt

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 14th East European Conference Adbis 2010 Novi Sad Serbia September 2010 Proceedings Lncs 6295

Authors: Barbara Catania ,Mirjana Ivanovic ,Bernhard Thalheim

2010th Edition

3642155758, 978-3642155758

More Books

Students also viewed these Databases questions

Question

3. How has e-commerce transformed marketing?

Answered: 1 week ago