title: Relational Database and Normalization for Relational Tables
body: <p>Im trying to figure out what the appropriate way to setup a database would be given this scenario:</p>
  <p>I am creating a Movie / TV database.  A movie may have multiple genres and a tv show may have multiple genres.</p>
  <p>Essentially what I am wondering is if you have a Movie table, TV table... should you:</p>
  <ol>
  <li><p>have a MovieHasGenre table consisting of a foreign key to the Movie table and a regular field for the genre value</p>
  <p>or</p>
  </li>
  <li><p>have a MovieHasGenre table AND a Genre table where the MovieHasGenre has two foreign keys, one pointing to the Movie in the Movie table the other pointing to the Genre in the Genre table</p>
  </li>
  </ol>
  <p>Im really not sure if this is something standardized or just involves preference.  Do we have concerns with speed as it seems removing the Genre table is one less join.</p>