Your program should consist of a continuous loop in which:
I am not requiring anything fancy in the way of interface.
For example, if you do not use a Web form, then
a menu printed via printf is OK. Also, handling of SQL errors
can be quite simple. As a minumum, write an sqlerror routine
that just prints the error
message from PostgreSQL. I am
especially interested in how
effectively you can utilize the database schema you have designed to
support interesting and/or engaging user interactions.
Submit your program and sufficient documentation for me to run
it. At this point, your database should be populated with
meaningful data. This means that the values of attributes in your
relations should not be random strings. As before, please create
a tar (or zip) file named <your-db-name>p7.tar and expands to
create a directory <your-db-name>p7, which contains any files
relevant to your program for this assignment.
If you build a Web interface to your database that allows
the sorts of options described above,
then in addition to your code,
please submit the URL and some sample data values that
will give nontrivial responses to your queries.
In this case, your project should be kept on some server that is
such as with your student home page or a machine that you control that
happens to have static IP address.
You will have 5 to 10 minutes in class on Wednesday or Friday
December 8th or 10th to demonstrate your program. You should
prepare a short presentation that describes the features of your
Project and exercises the functions of the interface as described
above. You are not required to demonstrate every interface option
if you want to spend more of your time describing interesting features
of your Project. (However, I will be testing every option with
several inputs so make sure they all work.)
Since each of you will be demonstrating your Project from my laptop,
make sure you submit your assignment with all necessary files by the
due date and time (12:45pm on the due date).
Acknowledgements: Most of the material for the project descriptions and assignments has been taken from Professor Ullman's website.