How many database tables have to be created for this java application

hi ,
can any body help me regading this task.
in my project i have to develop a web application in which it has to be. like.. is related to product related consumer action. where it has to show first the home category homepage of the product,subcaterories of the products,model of the prodcuct . example like if

the home category is ---> electronic applications
the subcategiry of the homecaterogy is -->tv,washing machine,radio,grinders
and inside subcategory i.e when user clicks on the subcategory of the tv then the all tv model company names as to be shown like lg,sony,samsung, & when when user clicks on lg then my requiremnt is to show lg brand all models & when user select on praticular model then for that partcuilar mode li have to show the speciaction of the partcicular model & when user can compare the prodcuts all by selecting 2 or 3 models then i have to show the comparsion of the products i.e specifation of the model & product price like that

for this project can any one sugest that how many tables i have to be created in backend database to work the application as of my requirement



categ subacategory1 subcategory2 brands
ex2: Home > Household Appliances > Washers & Dryers > Washing Machines > LG Electronics Washing
models
Machines > LG Electronics WM 1437 WFD
LG Electronics WM 1438 WF



thanks ,
kumar

It would probably be easiest to have two tables...

the first would be categories:

categoryId (PK)
parentCategory (FK) -- nullable
categoryName

the second would be brands:

brandId (PK)
caegoryId (FK)
brandName

Using this schema you can navigate categories using recursion. (If a parentCategoryId is null then it is a root category)

Hope it helps