title: How I might to create the tables for a vehicle database?
body: <p>MAKE - MODEL - YEAR - MOTOR are the entities. I'm working with these 4 entities, but I haven't found the best design (I guess is wrong)</p>
  
  <pre><code>Motor
  - MotorID
  - MotorName
  
  Model
  - ModelID
  - MotorID
  - ModelName
  
  Year
  - YearID
  - YearName
  - ModelID
  
  Make
  - MakeID
  - MakeName
  - YearID
  </code></pre>
  
  <p>I was watching this website to investigate how is organized: <a href="http://www.rockauto.com/catalog/raframecatalog.php" rel="nofollow">http://www.rockauto.com/catalog/raframecatalog.php</a></p>
  
  <p>I'm still having doubts about the design fot these four tables. </p>