Consider the following tables (relationship schemes):

ROOM (Name, Number)

COURSE (Id, Name, Subject)

ROOMBOOKING (Course, Room , Date)

(Primary keys are in bold.)

ROOMBOOKING.Course constitutes foreign key towards COURSE.Id

ROOMBOOKING.Room constitutes foreign key towards ROOM.Name

Formulate the following questions in SQL and relational algebra:

a) Which rooms have been booked for Database Methodology? Enter the names of the halls + number of people as each room holds.

b) Which courses have booked all rooms?

c) Which rooms have never been booked?

Formulate the following question in SQL:

d) Which course (s) have booked the most rooms?