## Students

StudentID | FirstName | LastName | BirthDate
--- | --- | --- | ---
1 | John | Doe | 2003-06-15
2 | Jane | Smith | 2001-07-28
3 | Michael | Johnson | 2002-09-10
4 | Emily | Williams | 2000-10-20
5 | David | Brown | 1999-11-25

## High_Schools

SchoolID | Name | Address
--- | --- | ---
1 | East High School | 123 Main St
2 | West High School | 456 Elm St

## College

CollegeID | Name | Location
--- | --- | ---
1 | University of Science | 789 Maple Ave
2 | Tech University | 101 Oak St

## Enrollments

EnrollmentID | StudentID | HighSchoolID | CollegeID
--- | --- | --- | ---
| (→ Students.StudentID) | (→ High_Schools.SchoolID) | (→ College.CollegeID)
1 | 1 | 1 | 1
2 | 2 | 2 | 2
3 | 3 | 1 | 1
4 | 4 | 2 | 2
5 | 5 | 1 | 1

## Subjects

SubjectID | SubjectName
--- | ---
1 | Mathematics
2 | Physics
3 | English Literature
4 | History
5 | Computer Science

## CourseOfferings

OfferingID | SubjectID | Semester | Year
--- | --- | --- | ---
| (→ Subjects.SubjectID) |  |
1 | 1 | Spring | 2021
2 | 2 | Fall | 2020
3 | 3 | Winter | 2022
4 | 4 | Summer | 2021
5 | 5 | Autumn | 2022

## StudentCourses

StudentCourseID | EnrollmentID | OfferingID | Grade
--- | --- | --- | ---
| (→ Enrollments.EnrollmentID) | (→ CourseOfferings.OfferingID) |
1 | 1 | 1 | A
2 | 1 | 2 | B
3 | 2 | 3 | C
4 | 2 | 4 | D
5 | 3 | 5 | F