Attendance table in sql server 2005

Question

Hai guys,
My web application stores attendance of employees daily..

• How to design an attendance table in sql server 2005?

I tried to figure it like this, Attendance table will contain columns EmpId,MonthId,1,2,3,4.....31..

• Is this ok enough to hold attendance?

Any siggestions....

Answer 1

Might be of your interest. http://stackoverflow.com/questions/1998298/storing-attendance-records-in-the-database

Answer 2

Depending on how you need to query the database, that approach could be the most efficient. However, I'd probably use the columns employee_id of integer, date of datetime.

While there would be many more rows this way, I think it makes a lot more sense.