Menu linking subpages

Good afternoon and thanks for reading my post
I’m after some advice regarding how to arrange / create a menu with clickable sub menus.
My website is a pharmacy website where I would like a main " medicines" menu that once opened, offers further options i.e. Allergy, Cold & Flu, Skincare etc.

I have started creating a database linked to a dynamic page for each product just not sure whether I could put all the products from different categories ie allergy, cold & flu, skincare in the same database or should I create a database for each category?

Thanks for reading, any help is greatly appreciated.

Check out this article about creating dynamic page.
Regarding the menu, do you want to create a sub menu for the dynamic items? or sub menu for non-dynamic pages?