limitations of the system:

the system deals with atomic predicates of the type (A op c), where A is any attribute and C is constant

the predicates have to be inconjunction only (OR, NOT, IN ) are not allowed

select * is not allowed. attributes have to be named explicitely

all tables should have unique attribute names : important for relationLookup table
modify tables : columnname "name" changed to "dname" in table D
modify all affected tables and java code


Issues:

resultSet can be iterated only once. Hence you will have to find a way to display the results to the user

postProcessing-modified query. decide what is to be stored in the querytable. ( original or modified query )