## Programs

ID | Name | Type | StartYear | EndYear
--- | --- | --- | --- | ---
1 | International Baccalaureate | High School Diploma | 2018 | 2020
2 | Advanced Placement | High School Diploma | 2019 | None

## Students

StudentID | FirstName | LastName | Age | RegistrationDate
--- | --- | --- | --- | ---
1 | John Doe | Doe | 17 | None
2 | Jane Smith | Smith | 16 | None

## Enrollments

EnrollmentID | StudentID | ProgramID
--- | --- | ---
| (→ Students.StudentID) | (→ Programs.ID)
1 | 1 | 1
2 | 2 | 2

## Credits

CreditID | EnrollmentID | CreditsEarned | Grade
--- | --- | --- | ---
| (→ Enrollments.EnrollmentID) |  |
1 | 1 | 30 | A
2 | 1 | 20 | B+
3 | 2 | 30 | C
4 | 2 | 25 | A-

## International_Baccalaureate_Program

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.

## Advanced_Placement_Program

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.