| studentID | firstName | lastName | dateOfBirth |
|---|---|---|---|
| 1 | John | Doe | 2000-01-01 |
| 2 | Jane | Smith | 2001-02-02 |
| 3 | Alice | Johnson | 2002-03-03 |
| 4 | Bob | Williams | 2003-04-04 |
| programID | educationProgram |
|---|---|
| 1 | International Baccalaureate Program |
| 2 | Advanced Placement Program |
| 3 | Associates Degree Program |
| 4 | Bachelors Degree Program |
| enrollmentID | studentID | programID |
|---|---|---|
| (→ Students.studentID) | (→ EducationPrograms.programID) | |
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 3 | 2 |
| 4 | 4 | 3 |
| gradeID | enrollmentID | credits |
|---|---|---|
| (→ EnrolledStudents.enrollmentID) | ||
| 1 | 1 | 30 |
| 2 | 2 | 30 |
| 3 | 3 | 30 |
| 4 | 4 | 30 |
| 5 | 1 | 36 |