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 |