Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Database Schema: Sailors (sid, sname, rating, age) Boats (bid, color) Reserve (sid, bid, date) Find sids and snames of sailors whove reserved a red or
Database Schema:
Sailors (sid, sname, rating, age) Boats (bid, color) Reserve (sid, bid, date)
Find sids and snames of sailors whove reserved a red or a green boat
(SELECT S.sid, sname FROM Sailors S, Boats B, Reserves R WHERE S.sid=R.sid AND R.bid=B.bid AND B.color=red) UNION (SELECT S.sid, sname FROM Sailors S, Boats B, Reserves R WHERE S.sid=R.sid AND R.bid=B.bid AND B.color=green)
What do we get if we replace UNION by EXCEPT ALL?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started