Create Attendance Table for School Students

Other SQL Server Topics
1

Hi Friends,

BASED ON THIS IMAGE I NEED TO CREATE THE DATABASE.

I need to create a Tables for Attendance for School.
As of now i have Created with these column Names
StudentId,ClassID,SectionID,Date,,Status,Reason.
So I will store each and every students attendance in single row.
I think it will take huge space is there any other structure for Attendance to do it simple.

Please suggest me.

2

StudentId,ClassID,SectionID this should be different table
StudentId,Date,,Status,Reason these should be another table.
make relationship using student id

3

Hi ,
If i create these two table.
To which tables i need to insert the attendance data.Can u tell please

4

StudentId,Date,,Status,Reason in this table you have to insert daily attendance

5

Thank you for your support Vigneshwar !! :blush: