title: Use a composite key as the primary key or have 2 foreign keys and another seperate field as the primary key?
body: <p>I have the following tables:</p>
  
  <p>| student |</p>
  
  <ul>
  <li>studentID(P)</li>
  <li>Name</li>
  <li>...</li>
  </ul>
  
  <p>| Jobs |</p>
  
  <ul>
  <li>JobID(P)</li>
  <li>Job_Name</li>
  <li>...</li>
  </ul>
  
  <p>| Application |</p>
  
  <ul>
  <li>JobID</li>
  <li>StudentID</li>
  <li>ApplicationID</li>
  <li>...</li>
  </ul>
  
  <p>should I get rid of ApplicationID in the Application table and use JobID and StudentID as a composite primary key or should I have these as foreign keys and use ApplicationID as the primary key?</p>
  
  <p>note: If it makes a difference I will be applying constraints such as students can accept only one application, have 3 weeks after it being offered to accept it etc. </p>
  
  <p>Thanks</p>