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 |