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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!