Student Rosters

The Rosters table captures detailed information about which students attend which classes. It includes fields like Class Name, Period, Student Name, and Attended status. This table serves the vital role of tracking student attendance and participation in each class, making it easy for teachers and administrators to ensure proper attendance management.

The Classes table holds information about each individual class. It includes details such as Course Name, Room, Teacher, and a Class Description. This table helps in organizing class schedules and assigning specific teachers to each course, ensuring that class administration is well-managed and clearly documented.

The Courses table stores all the academic courses offered. Each entry contains the Course Name, Course Code, and Subject, along with the course's Level Code. This table serves to standardize the curriculum and provides a clear overview of the academic offerings available for students.

The Rooms table tracks the physical locations where classes take place. It includes details like Room Number and Location, helping to manage room assignments and ensure that classes are appropriately scheduled in available spaces.

The Students table contains personal and academic details about each student. Information such as First Name, Last Name, Date of Birth, and Gender is stored, along with other relevant details. This table is critical for managing student records and ensuring accurate and up-to-date student information is maintained.

The Teachers table holds information about the educators responsible for teaching the classes. It includes fields like First Name, Last Name, Date Appointed, and Date Left. This table is vital for tracking the teaching staff, their qualifications, and their class assignments, providing an organized overview of the faculty.

In summary, the "Student Rosters" database ensures efficient management of students, teachers, and class information, while offering a comprehensive system to track attendance and academic details. It enables educational institutions to organize and access critical data for better administration of their academic programs.