| teacher_id | full_name |
|---|---|
| 1 | John Doe |
| 2 | Jane Smith |
| 3 | Michael Brown |
| 4 | Emily White |
| 5 | David Black |
| classroom_id | room_number | capacity |
|---|---|---|
| 1 | 7 | 30 |
| 2 | 12 | 28 |
| 3 | 6 | 25 |
| 4 | 9 | 32 |
| 5 | 11 | 27 |
| 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. |
| 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_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 |