Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Relational Algebra Exercise Questions Consider the Sailors-Boats-Reserves DB described in the text. S (sid, sname, rating, age) B (bid, bname, color) R (sid, bid, date)
Relational Algebra Exercise Questions Consider the Sailors-Boats-Reserves DB described in the text. S (sid, sname, rating, age) B (bid, bname, color) R (sid, bid, date) Give a Relational Algebra expression for each of the following operations: 1. Find the colors of boats reserved by Albert. 2. Find all sailor id's of sailors who have a rating of at least 8 or reserved boat 103. 3. Find the names of sailors who have not reserved a red boat. 4. Find the sailor id's of sailors with age over 20 who have not reserved a red boat. 5. Find the names of sailors who have reserved at least two boats. 6. Find the names of sailors who have reserved all boats. 7. Find the names of sailors who have reserved all boats called BigBoat. 8. Find the sailor id's of sailors whose rating is better than some sailor called Bob. 9. Find the sailor id's of sailors whose rating is better than every sailor called Bob. 10. Find the sailor id's of sailors with the highest rating
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