title: Creating related tables in mysql database
body: <p>i have a project at hand and it requires me to set up a database to save up product, currently i have product table, color table size table as below</p>
  
  <pre><code>color table
  colorId(PK)
  color
  procductId(FK)
  
  size table
  sideId(PK)
  size
  productId(FK)
  </code></pre>
  
  <p>i can relate this 2 tables to product, now my problem is i need to relate color table and size table , take for example i have this following product:
  Men's Wicking Polo shirt, this single shirt might have different varieties like different color and different sizes like...</p>
  
  <pre><code> PRODUCT NAME             SIZE         COLOR
   Men's Wicking Polo:      S, M, L      RED GREEN BLUE ORANGE
  </code></pre>
  
  <p>Now my question is: In a situation where there is different color for different sizes say size S is available only in RED and BLUE color, and color GREEN only have size M available while color ORANGE have size S and L available , how do i relate this two table to store this information for easy retrieval  </p>
  
  <p>any help on ths will be appreciated, thanks in advance</p>