## Teachers

teacher_id | full_name
--- | ---
1 | John Doe
2 | Jane Smith
3 | Michael Brown
4 | Emily White
5 | David Black

## Classrooms

classroom_id | room_number | capacity
--- | --- | ---
1 | 7 | 30
2 | 12 | 28
3 | 6 | 25
4 | 9 | 32
5 | 11 | 27

## Subjects

subject_id | name | description
--- | --- | ---
1 | Mathematics | The study of numbers, quantities, shapes, patterns and structures.
2 | English Literature | The study of written works and their social contexts.
3 | Physical Education | The development of physical fitness and skills through sports and activities.
4 | History | The study of past events and their impact on present-day society.
5 | Art | The expression of creativity and imagination through various forms of visual arts.

## Students

student_id | first_name | last_name | date_of_birth | enrollment_date
--- | --- | --- | --- | ---
1 | Alice | Johnson | 2003-05-15 | 2020-09-01
2 | Bob | Williams | 2004-06-20 | 2020-09-01
3 | Carol | Martinez | 2005-07-10 | 2020-09-01
4 | Daniel | Garcia | 2006-08-15 | 2020-09-01
5 | Eva | Lee | 2007-09-05 | 2020-09-01

## Teachers_Classrooms

teachers_classrooms_id | teacher_id | classroom_id | start_date | end_date
--- | --- | --- | --- | ---
| (→ Teachers.teacher_id) | (→ Classrooms.classroom_id) |  |
1 | 1 | 1 | 2021-08-30 | 2022-05-31
2 | 2 | 2 | 2021-08-30 | 2022-05-31
3 | 3 | 3 | 2021-08-30 | 2022-05-31
4 | 4 | 4 | 2021-08-30 | 2022-05-31
5 | 5 | 5 | 2021-08-30 | 2022-05-31
6 | 2 | 1 | 2021-08-30 | 2022-05-31
7 | 3 | 1 | 2021-08-30 | 2022-05-31
8 | 4 | 1 | 2021-08-30 | 2022-05-31
9 | 5 | 1 | 2021-08-30 | 2022-05-31