Students
StudentID | FirstName | LastName | BirthDate | EnrollmentDate |
1 | John | Doe | 1998-07-26 | 2024-03-08 |
2 | Jane | Smith | 2001-04-11 | 2024-03-08 |
3 | Michael | Brown | 1996-11-05 | 2024-03-08 |
4 | Emily | White | 2000-08-20 | 2024-03-08 |
5 | David | Green | 1995-02-23 | 2024-03-08 |
Teachers
TeacherID | FirstName | LastName | HireDate |
1 | Mr. | Davis | CURRENT_DATE |
2 | Ms. | Garcia | CURRENT_DATE |
3 | Dr. | Martinez | CURRENT_DATE |
4 | Prof. | Wilson | CURRENT_DATE |
5 | Mrs. | Perez | CURRENT_DATE |
Classes
ClassID | CourseName | Semester | Year | TeacherID |
| | | | (→ Teachers.TeacherID) |
1 | Maths | Fall | 2021 | 1 |
2 | Physics | Spring | 2021 | 2 |
3 | English Literature | Summer | 2021 | 3 |
4 | History | Autumn | 2021 | 4 |
5 | Biology | Winter | 2021 | 5 |
Classrooms
ClassroomID | LearningEnvironment | Capacity | ClassID |
| | | (→ Classes.ClassID) |
1 | Classroom | 30 | 1 |
2 | Classroom | 35 | 2 |
3 | Virtual Room | 30 | 3 |
4 | Virtual Room | 32 | 4 |
5 | Classroom | 25 | 5 |