Attendance Register

[vnseum]

I am developing a software for a School. I need to develope an Attendance register for Students and One for Teachers. I am Stuck on a Database Design. I am thinking that I would need to build a Table with 33 fields.
Like StudentID, Name, FatherName, and 30 fields (one each for a Day in the month) .
Can anyone help me in Table Design for this scenario as I am not setsefied with the table design of mine.

[RaviIntegra]

I can't understand your logic, i will give you a structure, try this if it is ok then you proceed it.

Table Name: mstStudent
Fields
StudentId (Primary key)
StudentName
FatherName
and other fields

Table No2:trnStudent
sl_no
StudentId
date
present (Yes/No type)

[leinad31]

Use an excel sheet to layout your base "tables" and compare that to the views/recordsets you'll need for the outputs/display.

The good thing with the excel sheet is you have a temp row-column interface to work with and fill up with temp/sample data... you can make printouts to show your groupmates/teacher/etc... and later on you can easily insert SQL the sample data to your actual database once your satisfied with the design.

[Hack]

Moved to database development