| 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. |