Students

StudentIDFirstNameLastNameBirthDateEnrollmentDate
1JohnDoe1998-07-262024-03-08
2JaneSmith2001-04-112024-03-08
3MichaelBrown1996-11-052024-03-08
4EmilyWhite2000-08-202024-03-08
5DavidGreen1995-02-232024-03-08

Teachers

TeacherIDFirstNameLastNameHireDate
1Mr.DavisCURRENT_DATE
2Ms.GarciaCURRENT_DATE
3Dr.MartinezCURRENT_DATE
4Prof.WilsonCURRENT_DATE
5Mrs.PerezCURRENT_DATE

Classes

ClassIDCourseNameSemesterYearTeacherID
(→ Teachers.TeacherID)
1MathsFall20211
2PhysicsSpring20212
3English LiteratureSummer20213
4HistoryAutumn20214
5BiologyWinter20215

Classrooms

ClassroomIDLearningEnvironmentCapacityClassID
(→ Classes.ClassID)
1Classroom301
2Classroom352
3Virtual Room303
4Virtual Room324
5Classroom255