How to manage products materials

I need to make a mysql db to manage products and how to recycle them.

For example I have a box of cookies and here you can have "paper", "plastic", "organic material", etc.

I can make a table named "products" and another one named "material" but how many rows I must add in products table?

For example I could make ten rows in "products" table like picture1, 2, etc. linked to "material" table where I could have just five or six fields!

When user will see the picture of his box of cookies he'll see "put in plastic bin" this is what I'd like to do...

Regards.
GabrieleMax Received on Sun Jan 11 2015 - 19:03:16 CET