Homework 4
CS320, Spring 2013


Due: Thursday, June 6

Please deploy your application on CS3, and upload all source files to CSNS. The source files should include all the source code, documentation (optional), and an HTML file hw4.html which contains a hyperlink to your application on the CS3 server. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

[Readings]

[MiniGOG] (80pt)

Modify the MiniGOG application you developed in Homework 3 so that it stores data in a database instead of in the application scope. Again, the application must use MVC architecture, and all features described in previous assignments must work; otherwise you will not receive any credit.

For this assignment, in addition to the application source code, you also need to turn in an SQL script file hw4.sql which contains the statements to create and populate all the tables in the database.

[Extra Credit] (+40pt)

Allow users to indicate whether a review is helpful. For example:

[Rate Review]

Note that a user can only rate a review once.