Homework 6
CS520, Spring 2011


Due: Saturday, November 26

Package all the source files of your project into a zip file as you did 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.

[Rubrics for CSNS2]

Continue to work on Rubrics for CSNS2 and implement the following functions. This assignment builds on top of your work in the previous assignments, so make sure that all the functions from the previous assignments work properly; otherwise you will not receive any credit.

1. (40pt) Associate rubrics with assignments.

Modify Add Assignment and Edit Assignment page to allow an instructor to associate and de-associate rubrics to an assignment. Good and original UI design for this function will receive up to 15pt extra credit, and particularly bad UI design will receive up to 10pt extra penalty.

2. (40pt) Full Text Search.

A user may perform full text search on rubrics. The search should include rubric names, criteria names, and quality descriptions. The search results should be ordered by their relevancy scores with the most relevant result first. For each rubric in the results, display the rubric name, and the part of the text that matches the query with the query terms highlighted. Clicking on the rubric name should take the user to the page showing the details of the rubric.

This feature must be implemented using the full text search functionality provided by PostgreSQL.

3. (Extra Credit +20pt)  Full text search with autocomplete.

Enhance your FTS implementation with the Autocomplete widget provided by jQuery UI.

[About Submission and Grading]

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

To test your project, we will use the following SQL scripts in your zip file 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 any errors.