Hello... Can anybody explain me Ebay or something like that database structur.Do All Item Categoris Store in One Table(with Differnt types)or do they story in many table .ex books for one table,jewellery in another table and so on.if they are store in differnt tables how do we search them ? according to my knowledge we have select from all table one by one i think it is not a good way.(are there any other way to do That ?) or plase explain me how to design such a web site and how to do fast and accurate search result.
Thank you