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>
Relations:
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.
Query1: <here put the english description of that query>
Query2: <here put the english description of that query>
Query3: <here put the english description of that query>
Query4: <here put the english description of that query>
Query5: <here put the english description of that query>
Ad-hoc Query:
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).