Students
student_id | first_name | last_name |
1 | Alice | Johnson |
2 | Bob | Smith |
3 | Charlie | Doe |
4 | David | Black |
5 | Eve | White |
Classes
class_id | course_name | teacher_name |
1 | Math | Mr. Brown |
2 | English | Mrs. Green |
3 | History | Ms. Blue |
4 | Science | Dr. Red |
5 | Art | Prof. Yellow |
Enrollments
enrollment_id | student_id | class_id |
| (→ Students.student_id) | (→ Classes.class_id) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
Attendance
attendance_id | student_id | date_attended |
| (→ Students.student_id) | |
1 | 1 | 2023-01-01 10:00:00 |
2 | 2 | 2023-01-01 10:00:00 |
3 | 3 | 2023-01-02 10:00:00 |
4 | 4 | 2023-01-02 10:00:00 |
5 | 5 | 2023-01-03 10:00:00 |
Grades
grade_id | student_id | class_id | grade |
| (→ Students.student_id) | (→ Classes.class_id) | |
1 | 1 | 1 | 8.5 |
2 | 2 | 2 | 7.5 |
3 | 3 | 3 | 6.5 |
4 | 4 | 4 | 9.5 |
5 | 5 | 5 | 7 |