Here we consider three tables for solving queries.
Instance S1 of Soldiers
sid sname rating age
22 dustbin 7 45
31 lubber 8 55.5
58 rusty 10 35

 

Instance s2 of soliers
sid sname rating age
28 yuppy 9 35
31 lubber 8 55.5
44 guppy 5 35
58 rusty 10 35
Instance R1 of Reserves
sid bid day
22 101 10/10/96
58 103 11/12/96

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

(b) Find the names of sailors who have reserved at least two boats.
(c) Find the sids of sailors with age over 20 who have not reserved a red boat.
(d) Find the names of sailors who have reserved all boats. The use of the word all (or
every) is a good indication that the division operation might be applicable.
(e) Find the names of sailors who have reserved all boats called Interlake.

 

 

 

8Comments
karmjit joshi @karmjitjoshi
2 Oct 2017 08:39 pm
shivani @shivani1234
2 Oct 2017 11:31 pm

boats table is missing , please add that too

karmjit joshi @karmjitjoshi
3 Oct 2017 08:40 pm

shivani1234 only these tables are given in the question mam.

shivani @shivani1234
4 Oct 2017 10:25 am

then question is incomplete
or give me its source , i will try it

karmjit joshi @karmjitjoshi
5 Oct 2017 08:25 pm

shivani @shivani1234
6 Oct 2017 11:22 am

given question is incomplete as no proper tables are given

set2018 @setgate
5 Oct 2017 10:36 pm

which book ?

karmjit joshi @karmjitjoshi
7 Oct 2017 07:25 pm

mba dbms