ID | Name | Type | StartYear | EndYear |
---|---|---|---|---|
1 | International Baccalaureate | High School Diploma | 2018 | 2020 |
2 | Advanced Placement | High School Diploma | 2019 | None |
StudentID | FirstName | LastName | Age | RegistrationDate |
---|---|---|---|---|
1 | John Doe | Doe | 17 | None |
2 | Jane Smith | Smith | 16 | None |
EnrollmentID | StudentID | ProgramID |
---|---|---|
(→ Students.StudentID) | (→ Programs.ID) | |
1 | 1 | 1 |
2 | 2 | 2 |
CreditID | EnrollmentID | CreditsEarned | Grade |
---|---|---|---|
(→ Enrollments.EnrollmentID) | |||
1 | 1 | 30 | A |
2 | 1 | 20 | B+ |
3 | 2 | 30 | C |
4 | 2 | 25 | A- |
IBPid | IBPname | Description | Requirements |
---|---|---|---|
(→ Programs.ID) | |||
1 | IB Program A | An international education program offering a balanced curriculum. | Students take six subjects, including three higher level and three standard level courses. |
2 | IB Program B | Another international education program... | This program has slightly different requirements than Program A. |
APpid | APpname | Description | Requirements |
---|---|---|---|
(→ Programs.ID) | |||
1 | AP Calculus AB | A college-level calculus course. | The AP Calculus AB exam covers topics such as limits, derivatives, and integrals. |
2 | AP Physics | A college-level physics course. | The AP Physics exam consists of multiple-choice questions and free response questions on various topics in physics. |