SQLTeam.com | Weblogs | Forums

Create Attendance Table for School Students

sql2012

#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: