Programs

IDNameTypeStartYearEndYear
1International BaccalaureateHigh School Diploma20182020
2Advanced PlacementHigh School Diploma2019None

Students

StudentIDFirstNameLastNameAgeRegistrationDate
1John DoeDoe17None
2Jane SmithSmith16None

Enrollments

EnrollmentIDStudentIDProgramID
(→ Students.StudentID)(→ Programs.ID)
111
222

Credits

CreditIDEnrollmentIDCreditsEarnedGrade
(→ Enrollments.EnrollmentID)
1130A
2120B+
3230C
4225A-

International_Baccalaureate_Program

IBPidIBPnameDescriptionRequirements
(→ Programs.ID)
1IB Program AAn international education program offering a balanced curriculum.Students take six subjects, including three higher level and three standard level courses.
2IB Program BAnother international education program...This program has slightly different requirements than Program A.

Advanced_Placement_Program

APpidAPpnameDescriptionRequirements
(→ Programs.ID)
1AP Calculus ABA college-level calculus course.The AP Calculus AB exam covers topics such as limits, derivatives, and integrals.
2AP PhysicsA college-level physics course.The AP Physics exam consists of multiple-choice questions and free response questions on various topics in physics.