Question 13

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
$$\rho(Tempsids, (\pi_{sid, bid}Reserves)/(\pi_{bid }(\sigma_{bname = 'Ganga'} Boats)))$$,
$$\pi_{sname}(Tempsids \bowtie Sailors)$$
If / is division operation, the above set of relations represents the query


Create a FREE account and get:

  • Download Maths Shortcuts PDF
  • Get 300+ previous papers with solutions PDF
  • 500+ Online Tests for Free

cracku

Boost your Prep!

Download App