title: database schema design about clothes
body: <p>I'm working on a fashion store's inventory control, but stuck at the clothing model. </p>
  
  <p>There should be a Style class, </p>
  
  <pre><code>public class Style{
     String styleNumber;
     String[] colors;
     String[] sizes;
     int quantity;
  
  }
  </code></pre>
  
  <p>And also a detail Garment:</p>
  
  <pre><code>public class Garment{
         Style style;
         String color;
         String size;
         int quantity;
  
      }
  </code></pre>
  
  <p>For example, one style has two colors, and each color might has four sizes, therefore, the garments might have 2*4 . We need to query inventory of specific color, or size. </p>
  
  <p>Could you guys give me some hints about the database schema design about this?
  Thank you.</p>