title: How to adapt this simple relational model to a dimensional one?
body: <p>I have this fairly basic relational model for storing bicycle models. It contains 2 tables:</p>
  
  <pre><code>    (modelID, modelName, brandName)
      (modelID,  type, color, wheelSize, suspension, frameMaterial, brakeManufacturer, gearType, gearModel, yearProduced)
  </code></pre>
  
  <p>I've been asked to adapt it to a dimensional model.</p>
  
  <p>These would be the dimension tables :</p>
  
  <pre><code>    tbl_d_model(modelID, modelName)
      tbl_d_brand(brandID, brandName)
      tbl_d_color(colorID, color)
      tbl_d_type(typeID, type)
      tbl_d_wheel(wheelID, wheelSize)
      tbl_d_suspension(suspID, suspension)
      tbl_d_frameMat(frameID, frameMaterial)
      tbl_d_brakeMan(brakeId, brakeManufacturer)
      tbl_d_gear(gearID, gearType, gearModel)
  </code></pre>
  
  <p>And this would be the fact table:</p>
  
  <pre><code>    tbl_f_fact(modelID, brandID, colorID, typeID, wheelID, suspID, frameID, brakeID, gearID, yearProduced)
  </code></pre>
  
  <p>Is this an optimal  way of doing it? Is there a better way?</p>