I have the following set of tables but I don't care for the design. It seems like there should be a better way of doing this. Let me explain what's going on:
-A visitor comes to our website and has the option of inputting a promotional code when buying our product. The promotional code will be related to a category, and may or may not be related to a subcategory. The promotional code may or may not be related to an affiliate.
-Should the visitor skip the entry of a promotional code, they will be presented with the opportunity to select a category, and if that category has subcategories, a subcategory as well. The category/subcategory may or may not be tied to one or many promotional codes and, in turn, any affiliates that the related promotional codes are related to.
-A category or subcategory may be related to none, one, or many promotional codes.
I've trimmed the fat off of the diagram so it's easier to read. What would you do differently? Thank you in advance for your assistance.