I have a series of information that I need to store, but I'm really stumped as to how to store it.
The information is basically a product list.
First, we need to define a set of sizes in which a product is avaliable. There might be from one size through to 10 different sizes for each product, depending on what vendor supplies the product.
Then we need to store a price for each size for each product.
After the data is stored, I need to pull the data out so the each row contains the product name, and the different prices for the different sizes. The descriptors of these sizes would need to be pulled separately.
Each set of rows would be for one unique vendor, so the sizes will be the same for all products in a range.
Does this make any sense? Can any of you genius(es) suggest a table structure and query to make this happen.
Thanks
How do I structure these tables ....
Moderator: General Moderators
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
have you read this: http://www.oreilly.com/catalog/javadtab ... r/ch02.pdf
That should show you the path for a decision on how to draw the architecture of your database.
That should show you the path for a decision on how to draw the architecture of your database.