Field_Trips

tripIDfieldTripNamedate
1Educational Trip2021-09-01
2Scientific Excursion2021-08-30
3Nature Adventure2021-07-25
4Historical Tour2021-06-10
5Art Exhibition2021-05-01

Stops

stopIDstopLocation
1Zoo
2Museum
3Botanical Garden
4Planetarium
5National Park

Students

studentIDfirstNamelastName
1JohnDoe
2JaneSmith
3AliceBrown
4TomJohnson
5EmmaWilson

Teachers

teacherIDfirstNamelastName
1Mr.White
2Ms.Black
3Dr.Green
4ProfessorBlue
5AssistantRed

Field_Trips_Students

tripIDstudentID
(→ Field_Trips.tripID)(→ Students.studentID)
11
12
23
24
35

Field_Trips_Teachers

tripIDteacherID
(→ Field_Trips.tripID)(→ Teachers.teacherID)
11
22
33
44
55

Field_Trips_Stops

tripIDstopID
(→ Field_Trips.tripID)(→ Stops.stopID)
11
12
55
33
44
22
32
42
52