title: Logic for creating an attendance system in c# and any database(help needed with the db schema)
body: <p>I have to create an attendance management system of our college..
  .the Requirements are..
  there are 6 subjects</p>
  
  <ol>
  <li>every subject has a table for every month..</li>
  <li>every class conducted is recorded and is numbered from 1 to n..and the present candidates are given the count if present...</li>
  <li>at the end of every month, total classes taken by all 6 subjects are summed up...and total classes attended by each student is summed up and a percentage is calculated...(total present classes)/(total classes )*100...</li>
  <li>there are 120 students...</li>
  </ol>
  
  <p>please help me create an efficient way to create the databases...
  note....
  the application should allow you to view through all the absent classes he did not attend for reference..(so every absent class must be recorded)</p>
  
  <p>My..attempts:</p>
  
  <ol>
  <li>one way i tried was:
  create tables for each subject...then
  6 tables required</li>
  </ol>
  
  <p>cons:
  *every day must be a column and the copy of 6 tables should be created every month.
  i.e 6 sub*12 months =72 tables every year
  also a extra classes can be taken per subject...so if a subject is taken twice on the day,3 cases arrive--> present for both,absent for both,present for only one..*</p>
  
  <p>2..the second method I've tried is:</p>
  
  <p>create a table for each student with the same db schema ..(with subjects as columns )
  con:</p>
  
  <h2><em>12 students will require 120 tables</em></h2>
  
  <p>:P
  Any bright ideas guys...would really help if you give me ideas how to construct a db schema for this kinda application.......</p>
  
  <p>thankyou.....</p>