Working and Detailed Explanation of Attendance Management System
1) have to created 5 tables
⦁
User table for login username and Password
⦁
Student_table for storing the details of students ,have to register
⦁
Teacher_table for storing the teacher details
⦁
Subject_table subject details
⦁
Attendance_table stores the student attendance for a particular subject and calculate attendance percentage.
2)we used RDBMS in relating student-table,Subject_table,Attendance_table
To calculate students attendance percentage and his/her status. We used joints to connect these.
login page:
By entrying correct details , it will login to home page
Home page:
Home page contains all redirected links.
⦁
Users table with the values
⦁
And inserting new values into the table
⦁
Inserting the values into users table
⦁
Successfully inserted the values into users_table
STUDENT_TABLE:
⦁
Student_table containing 6 students details .
⦁
We are linking front-end with php and back-end with MYSQl
⦁
Here we are entering the student details
⦁
By clicking register button, the values are inserted into Student_table
⦁
Here we can see in the screenshot of inserting student details in front-end part and these details were stored in the Student_table.
⦁
NEW column is inserted into the student_table.
Teacher_table:
⦁
Teacher is registering
⦁
New Column in teachers table is inserted.
Subject_table:
⦁
Registering for new subject
⦁
New column is inserted into subject_table after clicking register button.
Attendance_table:
⦁
We have calculated the percentage of students attendance
⦁
Using joints we have displayed this Screenshot.
⦁
for example here jagadeesh is having attendance shortage.
⦁
Attendance is taken here.
⦁
We have to click present/ absent then save
⦁
Inserting the student attendance in the Attendance_table
⦁
Calculated and updated students attendance
⦁
Here jagadeesh attendance have increased after attending few classes.