Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Consider the following queries: Query 1: SELECT R.sid FROM Boats B, Reserves R WHERE B.bid=R.bid AND B.color'red' Query2: SELECT R.sid FROM Reserves R EXCEPT SELECT

Consider the following queries:
Query 1:
SELECT R.sid
FROM Boats B, Reserves R
WHERE B.bid=R.bid AND B.color'red' 
Query2:
SELECT R.sid FROM Reserves R EXCEPT SELECT R.sid
FROM Boats B, Reserves R WHERE B.bid=R.bid AND B.color='red'
What are the results of query 1 and query2 in part A, considering the following instances of Sailors and Reserves tables? 
SID BID 1 1 3 3 3 101 101 104 10-OCT-19 10-JUL-19 102 DAY 103 10-OCT-17 10-OCT-18 07-NOV-17 BID BNAME 103 

SID BID 1 1 3 3 3 101 101 104 10-OCT-19 10-JUL-19 102 DAY 103 10-OCT-17 10-OCT-18 07-NOV-17 BID BNAME 103 COLOR 101 Interlake blue 102 Interlake red Clipper 104 Marine green red

Step by Step Solution

3.33 Rating (144 Votes )

There are 3 Steps involved in it

Step: 1

QA The operator is used for NOT EQUAL TO operator while the opera... 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_2

Step: 3

blur-text-image_3

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

Using Excel & Access for Accounting 2010

Authors: Glenn Owen

3rd edition

1111532672, 978-1111532673

More Books

Students explore these related Databases questions