Students

studentIDfirstNamelastNamedateOfBirth
1JohnDoe2000-01-01
2JaneSmith2001-02-02
3AliceJohnson2002-03-03
4BobWilliams2003-04-04

EducationPrograms

programIDeducationProgram
1International Baccalaureate Program
2Advanced Placement Program
3Associates Degree Program
4Bachelors Degree Program

EnrolledStudents

enrollmentIDstudentIDprogramID
(→ Students.studentID)(→ EducationPrograms.programID)
111
221
332
443

StudentGrades

gradeIDenrollmentIDcredits
(→ EnrolledStudents.enrollmentID)
1130
2230
3330
4430
5136