Instructions are given in italics.
Your project should at least have the following template and functionality to get the first 50 points. If you want to do more fancy stuff, do so only after providing for the following features:
<Project Name> Team
Members: <Team-member names>
In the following, substitute actual names for Relation1, Relation2 etc. Have entries for five relations in your project, ideally representing different aspects of the database. Clicking a link on a relation name should execute an SQL query and list 10-20 tuples in that particular relation (of course, they don't work below). Your output should be presented on a separate web page in a neat orderly fashion, one row for each tuple and where columns are evident. Ensure that all columns have their headers listed and their types are clear (i.e., state which is an int and which is a char and so on).
In the following, substitute the english query description for a query to your database. You can use any query you like (including the ones we have given), as long as the query does not take more than 10 seconds to execute. This constraint is to prevent overloading the database with expensive queries that run for minutes or hours. You can use the LIMIT keyword to list a small number of tuples, say 10-20, that satisfy the query. Again, clicking a link on the query name should execute the appropriate SQL query and list the tuples that are the answer to that particular query. Make sure your output is neatly ordered and column names and types are evident. The output should appear on a separate page.
Here, provide a free-form box and two buttons called "Submit" and "Clear". The intent is that the user can enter any arbitrary SQL query in the box and click the submit button; The action should be that you should execute that query on the database and bring up the answers on a separate page, once again, in a neat orderly fashion. Notice that the input can be any legal SQL query (permissible under your DB system, of course).