I would like to design a database of all the shops I know.
For this reason I'd need to divide those by category.
How can I do it in an efficient and easily customizable way?
Is it sufficient to create a shops and a categories table or I need more (e.g. shops / categories / types) in order to put, for example, all car related shops in the same macrocategory but also be able do differentiate between a mechanic and a car stereo expert?