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 |