| StudentID | FirstName | LastName | DateOfBirth |
|---|---|---|---|
| 1 | John | Doe | 2003-06-18 |
| 2 | Jane | Smith | 2004-09-07 |
| 3 | Michael | Johnson | 2002-11-22 |
| 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 |
| CourseID | Teaching_Subjects | Teacher | RoomNumber | Capacity |
|---|---|---|---|---|
| 1 | Mathematics | Ms. Smith | 101 | 30 |
| 2 | English | Mr. Brown | 201 | 25 |
| 3 | History | Mrs. Johnson | 301 | 35 |