Skip to content
Related Articles

Related Articles

ISRO | ISRO CS 2017 | Question 13
  • Last Updated : 22 Mar, 2018
GeeksforGeeks - Summer Carnival Banner

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

ρ (Tempsids, (Ⲡ  sid, bid  Reserves)/(Ⲡ bid ( σ bname ='Ganga' Boats))),
Ⲡ sname (Tempsids ⋈ Sailors)

If / is division operation, the above set of relations represents the query

(A) Names of sailors who have reserved all boats called Ganga
(B) Names of sailors who have not reserved any Gangaboat
(C) Names of sailors who have reserved at least one Gangaboat
(D) Names of sailors who have reserved at most one Ganga boat


Answer: (A)

Explanation: According to Division operator, Tempsids gives sid and bid of who have reserved all boats called Ganga

And Ⲡ sname (Tempsids ⋈ Sailors) will return sname of sailors who have reserved all boats called Ganga

So, option (A) is correct.

Quiz of this Question

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up
Recommended Articles
Page :