FieldTrips
id | destination | date | purpose | budget | Number_of_students |
1 | New York | 2023-09-16 | Museum Visit | 5000.0 | 50 |
2 | Washington DC | 2023-08-20 | Monument Tour | 7500.0 | 30 |
StudyHalls
id | building | capacity | available_hours | number_of_students |
1 | Building A | 100 | 08:00 - 22:00 | 50 |
2 | Building B | 150 | 08:00 - 22:00 | 30 |
Teachers
id | name | subject | years_experience | office_number |
1 | Mr. Smith | Math | 10 | 123 |
2 | Ms. Johnson | History | 7 | 456 |
Classes
id | teacher_id | class_name | grade_level |
| (→ Teachers.id) | | |
1 | 1 | Algebra I | 9 |
2 | 2 | World History | 10 |
Students
id | firstName | lastName | studentId | birthDate | fieldtrip_participant | studyhall_user | class_id |
| | | | | | | (→ Classes.id) |
1 | John | Doe | JD123 | 2005-05-15 | 1 | 1 | 1 |
2 | Emma | Smith | ES456 | 2004-06-18 | 1 | 1 | 2 |