This assignment is the culmination of the course project. For it, you must create the final interactive system to support your online movie rental system. Since you should have all the database work completed by this point, this assignment will mainly involve the development of the JDBC, Javascript, JSP, HTML, and GUI code that allows users to interact with your online movie rental system.
In case you need help with completing this assignment, a tutorial on running JDBC in the translab and on using Javascript for building the GUI for the course project has been posted on Blackboard in the project assignments folder.
If you are using the translab for your final project demo, you will need to place web pages on the translab web server. To allow you to do this, web aliases for the database project have been created. You can access them using the following link:
The grading criteria for the demo will mainly focus on the elegance of your database design and user interface, the simplicity of your database interactions, the completeness of your implementation of the required transactions, and your ability to demonstrate and explain how your system works. Your GUI must provide all classes of users with all the functionality they need to get the job done.
On Monday, December 7, 2009, a sign-up sheet will be posted on my office door. Your team will sign up for a time on Thursday December 10, 2009 to demonstrate your system to the TAs and/or myself. All team members must be present for the final demo. Your system must run either on a transaction lab machine, or on a laptop you provide. In either case, you must be able to demonstrate all the functionality of your system during the 30-minute demo time frame. You should have loaded into your system the test data that was provided for Project Assignment No. 2. You will be asked to use the interface to add more data and to do several operations your system should support. We will also ask you to show us the source code you wrote and to describe how it works. In particular we will want to see some of the SQL statements you wrote and how they are passed to the DBMS and how their results are retrieved.
Please try to do an excellent job on this assignment, culminating in a fully functional and impressive-looking demo. The three top-rate teams will receive award certificates, which is a very nice thing to put on your resumé. All demos will take place in Room 2114 of the Computer Science Building (the Advanced Programming Lab) and must start on time due to the tight schedule. Arrive 30 minutes early and have your system ready to go when it is your turn.
Good Luck! And we'll look forward to seeing the results of your
efforts at your project demo.