Search engines are integral features to any well designed website, but how well does your search engine work? Most simple search engines work by querying one column of a database for the search terms.

To intuitively understand join operations, we first build a simple example database that stores grocery items and their corresponding categories. The category information is stored in the categories ...