Homework 6
CS520, Fall 2009


Due: Wednesday, November 25

Package all the source files of your project into a zip file using the zip Ant target you developed in Homework 1, and upload the zip file to CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

[Online Assignment for CSNS]

Continue to work on CSNS Online Assignment and implement the following functionality:

1. (50pt) Edit questions.

Allow an instructor to edit the questions of an online assignment before the assignment is published.

2. (50pt) Add questions from previous assignments.

When an instructor is creating an online assignment, the instructor should be able to search for questions in previous online assignments, and add the ones he or she wants to the current assignment. The search should be performed on the question descriptions and choices, and limited to the assignments for the same course (but not necessarily the same section or by the same instructor).

This feature must be implemented using the full text search support provided by PostgreSQL. Good UI for this feature will receive up to 10pt extra credit.

[About Submission and Grading]

Before submitting your work, commit all the changes to your Subversion repository and create a tag.

If you use any libraries that are not in the original CSNS and are not included in your csns.zip, please upload the library jar files together with csns.zip when you submit your work.

To test your project, we will use the following SQL scripts in your csns.zip to create, populate, and then clear the database:

Please make sure that these scripts are up to date and can be run in their entirety without generating any errors. You can check out http://sun.calstatela.edu/~cysun/public/cs520-grading/instructions.txt for more details about the grading procedure.