Students

StudentIDFirstNameLastNameBirthDate
1JohnDoe2003-06-15
2JaneSmith2001-07-28
3MichaelJohnson2002-09-10
4EmilyWilliams2000-10-20
5DavidBrown1999-11-25

High_Schools

SchoolIDNameAddress
1East High School123 Main St
2West High School456 Elm St

College

CollegeIDNameLocation
1University of Science789 Maple Ave
2Tech University101 Oak St

Enrollments

EnrollmentIDStudentIDHighSchoolIDCollegeID
(→ Students.StudentID)(→ High_Schools.SchoolID)(→ College.CollegeID)
1111
2222
3311
4422
5511

Subjects

SubjectIDSubjectName
1Mathematics
2Physics
3English Literature
4History
5Computer Science

CourseOfferings

OfferingIDSubjectIDSemesterYear
(→ Subjects.SubjectID)
11Spring2021
22Fall2020
33Winter2022
44Summer2021
55Autumn2022

StudentCourses

StudentCourseIDEnrollmentIDOfferingIDGrade
(→ Enrollments.EnrollmentID)(→ CourseOfferings.OfferingID)
111A
212B
323C
424D
535F