title: MYSQL DB structure - Car makers / models / parts cascading dropdown
body: <p>I'm building an app where user is asked to first select car maker, than model, than part, and than part no. The values for dynamic dropdown will be loaded via Ajax.</p>
  
  <p>What is the best way to store the values in mysql db? Should I have separate table for each dropdown? Like</p>
  
  <p><strong>Table car_makers</strong></p>
  
  <pre><code>+----+-----------+
  | id | car maker |
  +----+-----------+
  </code></pre>
  
  <p><strong>Table car_models</strong></p>
  
  <pre><code>+----+--------------+-----------+
  | id | car_maker_id | car model |
  +----+--------------+-----------+
  </code></pre>
  
  <p><strong>Table car_parts</strong></p>
  
  <pre><code>+----+--------------+----------+
  | id | car_model_id | car_part |
  +----+--------------+----------+
  </code></pre>
  
  <p>Or should I just make one super-large table?</p>