Question 2:

sailors (sid, sname, rating, age)

reserved (sid, bid, day)

boats (bid, bname, color)

1. Find the names of the sailors who have reserved a red or green boat.

2. Find the names of the sailors with age over 20 who have not reserved a red boat.

3. Find the names of the sailor who have reserved all boats.

4. Find the color of the boat reserved by Smith.

Solve them using relational algebra

Introduction to database system

Solve it ASAP i will give you thumb up