Question: 5 ) Consider the following schema: Sailors ( sid , sname, rating, age ) Boats ( bid , bname, color ) Reserves ( sid ,
Consider the following schema:
Sailors sid sname, rating, age
Boats bid bname, color
Reserves sid bid, daydate
Write relational algebra expression for the following queries.
aFind the ids and names of sailors who have reserved two different boats on the same day.
bFind the names of all sailors who have reserved a boat but have not reserved a red boat.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
