Students

StudentIDFirstNameLastName
1JohnDoe
2JaneSmith
3MichaelJohnson
4EmilyWilliams
5DavidBrown

Programs

ProgramIDName
1Mathematics
2English Literature
3Biology
4History
5Physical Education

Enrollments

EnrollmentIDStudentIDProgramID
(→ Students.StudentID)(→ Programs.ProgramID)
116
227
338
449
5510

Grades

GradeIDEnrollmentIDGpaStandardized_Test_ScoreCourseName
(→ Enrollments.EnrollmentID)
113.51400Algebra I
223.71500Literature II
333.21350Biology III
443.81450World History IV
553.11300Physical Education V