Hi there! new here to dababase programing. I'm trying to design a database for a online store. Basically I need to have a product table and categories with multiple layers of subcategories. For example I have multiple categories that in turn have sub-categories

For example consider the following

Video Games -
- XBOX
- Original
- 360
- PS
- PS2
-PS3
-PSP
-WII
- DS
- PSP

Electonics -
- Computers
- Laptops
- Desktop
- TV
- LED
- LCD
- Plasma
......


Any help would be greatly appreciated.
Thanks

Carlos

see Categories and Subcategories