title: Database Design for Time Table Generation
body: <p>I am doing a project using J2EE(servlet) for Time Table Generation of College.
  There are Six Slots(6 Hours) in a Day </p>
  
  <pre><code>    4 x 1 HR Lectures
      1 x 2 HR Lab
  </code></pre>
  
  <p>There Are three batches ( 3IT, 5IT, 7IT)</p>
  
  <pre><code>   2 Classroom 
     1 LAB
  </code></pre>
  
  <p>Each slot in the time table will have</p>
  
  <pre><code>       (Subject,Faculty)
  </code></pre>
  
  <p>For Lab I will duplicate the slot.
  The Tables </p>
  
  <pre><code>    Subject(SubjectID  INT, SubjectName VARCHAR);
      Faculty(FacultyID INT,FacultyName VARCHAR,NumOfSub INT,Subjects  XYZ);
  </code></pre>
  
  <p>Here I am not able to decide the <code>DATATYPE</code> for subject. What should I do ? Since a faculty can teach multiple subjects ? Also how to link with Subject Table ?</p>
  
  <p>P.S. Using MySQL Database</p>