log inhelp

 | 

  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

COP4709 Assignment 11A - Full text indexing

Page history last edited by Dr. Ron Eaglin 9 years, 1 month ago

 Assignment 11A - Full-Text Indexing

 

Objectives

 

Learn to use Full-text indexing to enhance query

 

Assignment

 

You will be using your menu database.

 

1. You will need to add about 4-5 menu groups and at least 4 items per group.

 

2. You will create a full text index on the item descriptions.

 

3. Demonstrate a full text query that returns all items that contain two search items such as "Delicious" AND "Spicy". The return should be organized by menu group, with the items in that group that match the full text pattern displayed with their descriptions.

 

Create a word (or pdf) document that has the query, approach, and results of your query.

 

Information

 

 

Estimated Completion Time

 

 The query will not take long once you figure it out, getting the data into the database will probably take longer.

 

Supporting Lectures 

 

Topic - Full Text Indexing

 

Questions and Answers

 

 

 

External Resources

 

 

 

Grading Criteria

 

 

 

Comments (0)

You don't have permission to comment on this page.

Printable version