[Project Listings for CSNS2]
Continue to work on Project Listings for CSNS2 and implement the following feature. 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) Full Text Search.
Add a search function to project listing to allow users to perform full text search on projects. The search should include project name and project description. The search results should be ordered by their relevancy scores with the most relevant result first. For each project in the results, display the project year, name, and description with the query terms highlighted. Clicking on the project name should take the user to the project details page.
This feature must be implemented using the full text search functionality provided by PostgreSQL.
[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.