I was having a doubt regarding the design of a database table to track students' attendance. Currently, my table `students` have atleast `4000` students.

Creating a database for attendance to track their attendance will have almost `4000*30days*12months => ~ 1,400,000` rows (neglecting vacations/ sundays).

The attendance table will have:

```
id (INT)
student_id (INT) 
course_id (INT)
data (DATETIME)
present/absent (TINYINT, as I'll store 1/0)
comments

```

I'm using `PHP/MySql`. With a table becoming so large, is there any other way?