Programming Project


TEST WORKLOAD

Queries:

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 RELATION

query6="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 RELATIONS

query7="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 3
Updated to include the exercise numbers in the 6th edition.


Zip file containing the ToyRDBMS code: ToyRDBMS.zip


More about Oracle Hints
Comments