Tuesday, 27 December 2016

Attendance Management System - DOWNLOAD LINK



Download

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.


DOWNLOAD


No comments:

Post a Comment