title: Store school timetable values in database
body: <p>I am able to design time table as shown in screen short.
  <a href="http://www.flickr.com/photos/110025772@N02/11101476955/" rel="nofollow">Screen Short</a></p>
  
  <p><strong>confusing part</strong>: How to store teacher id in database which is stored in another table. I have decided to store in following format</p>
  
  <p>Subject (already stored)</p>
  
  <pre>
  subject_id    subject_name       class_id      teacher_id
  </pre>
  
  <p>Time Table Master</p>
  
  <pre>
  tt_id     class_id
  </pre>
  
  <p>Time Table Data</p>
  
  <pre>
  ttd_id     tt_id      time      day     subject_id      teacher_id
  </pre>
  
  <p>Whereas timetable form only allows to select subject... how can I store teacher_id for each subject. Please guide me in right direction??</p>