CSc498/699B, Spring 1998
Project (Phase III)
Due: 3 June, 1998 (Wednesday)
The third and final phase will deal with
developing application program(s) so that the
database can be used by the users.
Depending on the application area, this would involve
writing embedded-SQL or Java-JDBC programs to perform certain actions
such as make a reservation, cancel a reservation, print the
passengers on a particular flight etc. for an airline
database; enrolling a student, drop/add, class schedule,
printing a transcript for a student etc. in a registration
database (see Tempo for hints);
placing an order in an online mail-order company database;
checking in/out of videos, printing invoices etc. in a
video-store database etc.
You may chose to implement the entire application
via a terminal-based menu-system. If you are familiar with GUI or similar
tools, you may use it to develop a fancier interface
and earn some extra credit.
Some remarks:
- Try to distribute the work evenly among the
group members. The idea is for every member in the
group to make contributions.
- Write at least one "reporting" function per group member.
(i.e. a function that produces a report of some sort from the database)
- Describe the various functionalities of your database
in the final chapters of the report and submit the
final report (which includes Phase I and II).
- Include a section in the report which describes the
contributions of each member of the group towards the
project. Do not worry: I am not going to grade individuals according to
their contributions, but if there is an obvious
discrepancy in the amount of work (such as one member never
showed up for meetings and never wrote any code!), I would
like to know about it!
- Please schedule 30 minutes during last week of classes
for your project demonstration.