Students

student_idfirst_namelast_name
1AliceJohnson
2BobSmith
3CharlieDoe
4DavidBlack
5EveWhite

Classes

class_idcourse_nameteacher_name
1MathMr. Brown
2EnglishMrs. Green
3HistoryMs. Blue
4ScienceDr. Red
5ArtProf. Yellow

Enrollments

enrollment_idstudent_idclass_id
(→ Students.student_id)(→ Classes.class_id)
111
222
333
444
555

Attendance

attendance_idstudent_iddate_attended
(→ Students.student_id)
112023-01-01 10:00:00
222023-01-01 10:00:00
332023-01-02 10:00:00
442023-01-02 10:00:00
552023-01-03 10:00:00

Grades

grade_idstudent_idclass_idgrade
(→ Students.student_id)(→ Classes.class_id)
1118.5
2227.5
3336.5
4449.5
5557