The Area being Modelled is :-
Products, Categories ansd Attributes

Subject: A schema for categories and products with properties/attributes
Question: I am looking into re-designing our product structure in our database.
          I would like to have products be able to be members of multiple categories.
          I would also like some help on the best way to implement properties/attributes against a category.
          The way our structure works now is that there are categories that have sub categories n levels deep
          with each sub category mainly defining a different characteristic.
          These finally drill down into a product level category/page that will have all the resources/information
          attached to it; including part numbers that we attach to this product level category.

          I have a db schema that might work but am unsure on how to implement correctly or if there is a better alternative.
          Any help/guidance would be huge.