Question

How large number of students attendance data saved into database?

Answer 1

Answer:

Create a single table for whole organisation and store empid,date,presentstatus as a row for every employee everyday.

Create a single table for whole organisation and store a single row for each day with a comma delimited string of empids which are absent.