ENTITY
*Product_category(ID,Category_Name)
*Product_Master(ID,Product_name,Category_ID)
*Product_Tag(Product_ID,TAG) Eg:tag(comma separate)
Using this kind of tables
using product name
*Select * from Product_Master where Product_name like '%<Search Word>%'
Using product category
*select * from...