GATE 2002
October 13, 2023GATE 2005
October 13, 2023Database-Management-System
| Question 878 |
Consider the following schema :
Sailors(sid,sname,rating,age)
Boats(bid,bname, colour)
Reserves(sid,bid,day)
Two boats can have the same name but the colour differentiates them.
The two relations
If / is division operation, the above set of relations represents the query
Sailors(sid,sname,rating,age)
Boats(bid,bname, colour)
Reserves(sid,bid,day)
Two boats can have the same name but the colour differentiates them.
The two relations
If / is division operation, the above set of relations represents the query
| Names of sailors who have reserved all boats called Ganga | |
| Names of sailors who have not reserved any Ganga boat | |
| Names of sailors who have reserved at least one Ganga boat | |
| Names of sailors who have reserved at most one Ganga boat |
Correct Answer: A