title: How to design a movie database?
body: <p>I'm trying to get my head round this mind boggling stuff they call Database Design without much success, so I'll try to illustrate my problem with an example.</p>
  
  <p>I am using MySQL and here is my question:</p>
  
  <p>Say I want to create a database to hold my DVD collection. I have the following information that I want to include:</p>
  
  <ol>
  <li>Film Title</li>
  <li>Actors</li>
  <li>Running Time</li>
  <li>Genre</li>
  <li>Description</li>
  <li>Year</li>
  <li>Director</li>
  </ol>
  
  <p>I would like to create relationships between these to make it more efficient but don't know how.</p>
  
  <p>Here is what I'm thinking for the database design:</p>
  
  <p><strong>Films Table => filmid, filmtitle, runningtime, description</strong></p>
  
  <p><strong>Year Table => year</strong></p>
  
  <p><strong>Genre Table => genre</strong></p>
  
  <p><strong>Director Table => director</strong></p>
  
  <p><strong>Actors Table => actor_name</strong></p>
  
  <p>But, how would I go about creating relationships between these tables?</p>
  
  <p>Also, I have created a unique ID for the Films Table with a primary key that automatically increments, do I need to create a unique ID for each table?</p>
  
  <p>And finally if I were to update a new film into the database through a PHP form, how would I insert all of this data in (with the relationships and all?)</p>
  
  <p>thanks for any help you can give,
  Keith</p>