Question: Consider the Relations and its attributes 1. Sailors(sid, sname, rating, age) 2. Boats(bid, bname, color) 3. Reserves(sid, bid, day) Write an algebra statement for 1.
Consider the Relations and its attributes
1. Sailors(sid, sname, rating, age)
2. Boats(bid, bname, color)
3. Reserves(sid, bid, day)
Write an algebra statement for
1. Show the name of all sailor
2. Show details of all sailors
3. Show all sailor name that their rating is 20.
4. Show the name of all red boat.
5. Show the name of red boat which starts with sea.
6. Show the red boat was reserved more than 5 days.
7. Find the name of the sailors whove reserved boat#1.
8. Find the names of the sailors whove reserved a red boat.
9. Find all sailor who have reserved a red or green boat.
do it all pls
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
