title: How to design table between three important columns (products,designs,colorImages) in SQL Server
body: <p>I designed three tables </p>
  
  <ul>
  <li>Products</li>
  <li>Designs</li>
  <li>Colorimages</li>
  </ul>
  
  <p>What is the best way to design extra tables to join these three table together: </p>
  
  <ul>
  <li>Each product have more than one design with more than colorimages of that design.</li>
  </ul>
  
  <p>Example</p>
  
  <pre><code>productid    designid  colorimageid   picturename
  1               1         1              img1
  1               1         2              img2
  1               2         1              img3
  1               2         3              img4
  1               3         1              img5
  2               1         1              img6
  2               1         2              img7
  2               2         1
  2               3         3
  2               3         4
  </code></pre>
  
  <p>How to design it with high performance ?</p>