### Programming Project

 TEST WORKLOADQueries:query1="SELECT * FROM R, S, T WHERE R.a = S.a and S.a = T.a;"query2="SELECT * FROM customers, flewon WHERE flightid = 'SW119' and flewon.customerid = customers.customerid;"query3="SELECT * FROM customers, flewon, flights WHERE flights.airlineid = 'CO' and flewon.customerid = customers.customerid and flewon.flightid = flights.flightid and customers.frequentflieron = 'CO';"query4="SELECT * FROM A, B, C, D WHERE A.b = B.b and B.b = C.b and C.b = D.b;"query5="SELECT * FROM customers, flewon, flights WHERE flights.airlineid = 'CZ' and flewon.customerid = customers.customerid and flewon.flightid = flights.flightid and customers.frequentflieron = 'CO';" # EMPTY RELATIONquery6="SELECT * FROM customers, flewon, flights WHERE flights.airlineid = 'CZ' and flewon.customerid = customers.customerid and flewon.flightid = flights.flightid and customers.frequentflieron = 'CZ';" # BOTH EMPTY RELATIONSquery7="SELECT * FROM customers, flewon, flights, airlines WHERE flights.airlineid = 'CO' and flewon.customerid = customers.customerid and flewon.flightid = flights.flightid and customers.frequentflieron = 'CO' and airlines.airlineid = flights.airlineid;"Relations:Other relations were as before.Relations A, B, C, D had identical schemas: (a integer primary key, b integer);And all had two tuples each:(1, 0)(2, 0)So the output of the Query 4 above should contain 16 tuples.====================================================================Any further announcements or details or errata will be posted on this webpage.Description of the Programming Project and HOMEWORK 3Updated to include the exercise numbers in the 6th edition.Zip file containing the ToyRDBMS code: ToyRDBMS.zipMore about Oracle Hints