title: How do I organize such database in SQLite?
body: <p>folks! I need some help with organizing database for application and I have no idea how to do it. Suppose following:
  There is a list of academic subjects. For each subject we need to have a list of academic groups, which attend this subject. Then, for each group we need to have a list of dates. And for each date we need to have a list of students, and whether this student was present that day or not. 
  I have ugly data structures in my mind, will appreciate any help. </p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>How do I see it:</p>
  
  <p>Table1(the first col is date and second is list student's id, who were present)</p>
  
  <pre><code>10/10/11 | id1, id2, id3
  
  10/11/11 | id1, 1d3, id5
  </code></pre>
  
  <p>Table2:</p>
  
  <pre><code>subject1 | id1 id2 id3
  
  subject2 | id3 id2
  </code></pre>
  
  <p>And again, ids are id of groups. Dont know how to connect  those tables. </p>