Database Management System - Old Questions

11. Consider a database system with following schemes;

Restaurant (Rname,Rlocation,Fname)

Cook(Cname,Cspeciality)

Worksat(Cname,Rname,Workinghrs,Shift)

Food(Fname,Cname,Category)

Now write SQL statements and relational algebra statements for following queries

a) Select the name and location of all restaurants.

b) Find the working hours of cook name "Sita".

c) Select name of the food cooked by "Ramesh".

d) Use join to select name of restaurants where food of category "breakfast" is available.

e) Find the name of cooks who work as "KFC"