Iam trying to design a database for catalog.It has main categoryes,subcategoryes at different level down & a products table.I have interconected all the entries in the products and category's through a mapping table which shows the parent of each category or the category to a product... If u have developed something similar to this please give me some advice..

thanks in advance