## 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