I am unsure how to properly (at all) enter product options for my products using the provided MySQL Database. Firstly, I have entered the more simple product data in the Products table, for instance a doormat with a ProductID of CMC-02x03 at a price of 23.99 etc. How do I specify that this doormat is available in Red, Green, Blue etc...
as a guess, should I go to the database table Options & then enter CMC-02x03 for the OptionID, then enter Red Green Blue in the field for OptionName?
Is there a document other than the Realtionship Diagram which provides general information on how to properly structure data in this multi-part database? Maybe a few examples of typical setups? I am honestly very confused by all of the Columns & Tables.