Attendance taker for student and teacher

Customer's requirements: Check In/Out Process: The system must allow the users to check the students that are absent or late with just one click. The system must be able to know the students that are taking the course and know the courses that are taken by a student. The system must be able to assign the students to the classes he/she is taken. And the system must allow the users to change the total hour of the class, and the date and time of the class. Users: The system will have an administrator and only the administrator can create users and classes. The system must allow the administrator to assign the user a username, a password, a role and to their related classes. And the system must allow the administrator to create two kinds of user: teacher user and student (public) user. The system must not allow the student user to use teacher user. Roles: The system should allow for two roles: Administrator and Users. Administrator role must be allowed to create, delete, update and edit the users and classes. And for the teacher users, they must be able to check the attendance in a very short time and edit the hour of class. And for the student users, they must be able to check their attendance percentage, the total absent hour and the date they absent. Security: Both teacher user and student user has their own user name and password to login to the system. And the system must be able to block the student user from using the teacher so that the student user can't change his/her attendance. Attendance Report: The system must provide a report that teachers can check the attendance of students from each class in different table. In the report, for a class there must be a table of all students' attendance percentage, top three students that absent most in the class and their absent percentage. And for the students, they can check their attendance percentage, the absent date or tardy date for each class in a table. Table Maintenance: The system must allow the administrator to maintain the data and update the information that is needed for the users. In this system there will be three tables: Teachers, Students, Course. The system will need the following information: Teachers: TeacherID, Name,CourseNumber Students: StudentID, Name, CourseNumber Course: CourseNumber, Title, StudentID, TeacherID Output Requirements Notification Letter: The system must send the first email when a student absent reach 5%, second email at 10% and third email at 15%. This notification basically contains the name of student, the course title, the teacher name, the absent percentage and the date he/she absent. And most importantly, in this email, the system must provide a link to confirm that the student receive the notification letter or not. If the system doesn't get the confirmation then the teacher can directly give the warning to the student. Warning Letter: The system must send a warning letter to the student who got all three notification letter and miss the attendance 20% or above 20%. The information in the letter is that the student cannot sit the exam anymore because he missed the attendance 20% or more. The figure below is the sample of warning letter that will be sending to the student whose absent percentage reached 5% 10% and 15%.