The purpose and use of queries

The three queries that I used for the database include:
1. Search by Name: This prompt allows the user to search for a single product by name. The disadvantage of this is that the user has to know the complete name of the item entered into the system.
2. Search by Type: This would be the most used query because it allows the user to view the whole range of products that they are searching for and can find out the price and the availability of the items.
3. Search by Product ID: This query would be used mostly by the stores staff because to remember all the ID’s of the product is very difficult.
The reasons for using all of these queries are to provide the user with a choice to use the query that is most convenient for them.