## Field_Trips

tripID | fieldTripName | date
--- | --- | ---
1 | Educational Trip | 2021-09-01
2 | Scientific Excursion | 2021-08-30
3 | Nature Adventure | 2021-07-25
4 | Historical Tour | 2021-06-10
5 | Art Exhibition | 2021-05-01

## Stops

stopID | stopLocation
--- | ---
1 | Zoo
2 | Museum
3 | Botanical Garden
4 | Planetarium
5 | National Park

## Students

studentID | firstName | lastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Alice | Brown
4 | Tom | Johnson
5 | Emma | Wilson

## Teachers

teacherID | firstName | lastName
--- | --- | ---
1 | Mr. | White
2 | Ms. | Black
3 | Dr. | Green
4 | Professor | Blue
5 | Assistant | Red

## Field_Trips_Students

tripID | studentID
--- | ---
(→ Field_Trips.tripID) | (→ Students.studentID)
1 | 1
1 | 2
2 | 3
2 | 4
3 | 5

## Field_Trips_Teachers

tripID | teacherID
--- | ---
(→ Field_Trips.tripID) | (→ Teachers.teacherID)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Field_Trips_Stops

tripID | stopID
--- | ---
(→ Field_Trips.tripID) | (→ Stops.stopID)
1 | 1
1 | 2
5 | 5
3 | 3
4 | 4
2 | 2
3 | 2
4 | 2
5 | 2