[BVVO]

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.

Continue your work in Homework 6 and implement the following features in BVVO.

1. (40pt) Full Text Search.

Add a search function to allow users to perform full text search on reviews. Both review title and review content should be included in the search. Search results should be ordered by their relevancy scores with the most relevant result first. For each review in the results, display the names of the lawyer and the reviewer, and the review title and content with the query terms highlighted. Clicking on the lawyer's name should take the user to the lawyer's page.

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

2. Extra Credit

•  (+50pt) Use Ajax to implement Netflix-style rating.
• (Up to +20pt) Good UI will receive up to 20pt extra credit, and particularly bad UI will receive up to 20pt extra penalty.

[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:

• src/main/scripts/bvvo-create.sql
• src/main/scripts/bvvo-drop.sql

Please make sure that these scripts are up to date and can be run in their entirety without any errors.