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 |