Students

StudentIDFirstNameLastNameAgeGradeLevel
1JohnDoe127
2JaneSmith138
3AliceBrown96
4TomGreen149
5MikeBlack105

Classrooms

ClassroomIDRoomNumberTotalCapacity
1A0130
2A0235
3A0340
4A0445
5A0550

Educators

EducatorIDFirstNameLastNameSubjectTaught
1Mr.SmithMath
2Ms.DavisEnglish
3Dr.MartinHistory
4Mrs.WilsonArt
5MissGarciaMusic

Enrollments

EnrollmentIDStudentIDClassroomID
(→ Students.StudentID)(→ Classrooms.ClassroomID)
111
222
333
444
555

Activities

ActivityIDActivityTypeDescription
(→ Educators.SubjectTaught)
1Field TripNone
2Study HallNone
3Laboratory ExperimentNone
4Outdoor SportsNone
5Art ExhibitionNone

ActivitySchedule

ScheduleIDActivityIDClassroomIDNumberOfStudentsDate
(→ Activities.ActivityID)(→ Classrooms.ClassroomID)
111502023-05-01 10:00:00
222502023-05-01 13:00:00
313252023-05-01 14:00:00
424402023-05-01 15:00:00
535302023-05-01 16:00:00