designing this database .... ?!
-
Hey guys, I've made this simple, as you can see in the picture I have some categories and subcategories, in this case Electronics > Television (check out this to understand better http://i56.tinypic.com/rmvifs.jpg) Television is a type of product which has some fields like (size, color, brand) that has to be saved in the database. there are many different types of products which have their own fields and their number is unknown therefore this cannot be done statically, it has to be done dynamically. in addition to all this, each field has values, there are three types of values true/false multiple choice single text the values for each field also needs to be stored in the database so when for instants TV is selected the fields are loaded + their values. I hope I were clear enough, would appreciate it if you could help out with the best design K1
-
Hey guys, I've made this simple, as you can see in the picture I have some categories and subcategories, in this case Electronics > Television (check out this to understand better http://i56.tinypic.com/rmvifs.jpg) Television is a type of product which has some fields like (size, color, brand) that has to be saved in the database. there are many different types of products which have their own fields and their number is unknown therefore this cannot be done statically, it has to be done dynamically. in addition to all this, each field has values, there are three types of values true/false multiple choice single text the values for each field also needs to be stored in the database so when for instants TV is selected the fields are loaded + their values. I hope I were clear enough, would appreciate it if you could help out with the best design K1
Could you please look into link you provided ? It's not redirecting properly.
Regards, Hiren.
My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator. -
Could you please look into link you provided ? It's not redirecting properly.
Regards, Hiren.
My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator. -
If you cut and paste the link, it seems to work. Anyway this might help.[^] Unfortunately, it looks remarkably like a lecturer's whiteboard with a homework problem, snapped on a mobile 'phone, but I could be wrong. :suss:
-
If you cut and paste the link, it seems to work. Anyway this might help.[^] Unfortunately, it looks remarkably like a lecturer's whiteboard with a homework problem, snapped on a mobile 'phone, but I could be wrong. :suss:
I am still out of luck, I am not getting to see image. Thanks for all your work.
Regards, Hiren.
My Recent Article: - Way to know which control have raised a postback
My Recent Tip/Trick: - The ?? Operator. -
it actually is my whiteboard and that's the problem I wanna find a solution for ! ;-) so have you got any idea guys ?
Well, I wouldn't tackle the problem that way at all. Assuming you are using a 'grown up' database, and you don't have millions of records under 'Electronics', then I would just have two tables. The first would hold the records of all the 'Electronics' items, with a 'Category' column containing a unique code for TV, DVD player and so on. Other than the essential columns, like Name etc, I would have Descr1, Descr2, Value1, Value2, etcetera, enough to accommodate the most complex item. Some columns would have normal names, for instance, 'Price', or 'Cost'. The second table would reference the first through the Category Code, have the same columns and column headers as the first table, but the rows would each contain descriptive values for the equivalent column headers in the first table.
