Consider the following relational database schema consisting of the four relation schemas: passenger (pid, ppname, pgender, pcity) agency (aid…

Consider the following relational database schema consisting of the four relation schemas:

passenger (pid, ppname, pgender, pcity)

agency (aid, aname, acity)

flight (fid, fdate, time, src, dest)

booking (pid, aid, fid, fdate)

a) Get the complete details of all flights to New Delhi

b) Get the details about all flights from Chennai to New Delhi.