## 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