Students

StudentIDFirstNameLastNameBirthDateEmail
1JohnDoe2000-01-01john.doe@example.com
2JaneSmith1997-06-28jane.smith@example.com

Educators

EducatorIDFirstNameLastNameSubject
1AliceBrownMathematics
2CharlieGreenEnglish Literature

Classes

ClassIDClassNameStartTimeEndTimeRoomNumber
1Calculus I08:00:0009:30:00101
2Literary Analysis09:45:0011:15:00102

Enrollments

EnrollmentIDStudentIDClassIDSemesterGrade
(→ Students.StudentID)(→ Classes.ClassID)
111Fall 2021A
222Winter 2022B+

Education_Programs

ProgramIDNameDescriptionCredits
1International Baccalaureate ProgramAn internationally recognized pre-university program...30
2International Baccalaureate ProgramThis program has a slightly different curriculum structure...31
3Advanced Placement ProgramThe AP program offers college level courses...30
4Advanced Placement ProgramThese courses can earn college credit upon completion...29