## Students

StudentID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2003-06-18
2 | Jane | Smith | 2004-09-07
3 | Michael | Johnson | 2002-11-22

## Enrollments

EnrollmentID | StudentID | CourseID | EnrolDate | FinalGrade
--- | --- | --- | --- | ---
| (→ Students.StudentID) | (→ Academics.CourseID) |  |
1 | 1 | 1 | 2021-09-01 | None
2 | 2 | 2 | 2021-09-01 | None
3 | 3 | 3 | 2021-09-01 | None

## Academics

CourseID | Teaching_Subjects | Teacher | RoomNumber | Capacity
--- | --- | --- | --- | ---
1 | Mathematics | Ms. Smith | 101 | 30
2 | English | Mr. Brown | 201 | 25
3 | History | Mrs. Johnson | 301 | 35