## 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