Students

StudentIDFirstNameLastNameDateOfBirth
1JohnDoe2003-01-15
2JaneSmith2002-06-28
3AliceJohnson2000-11-12
4MichaelWilliams1999-07-20
5EmmaMartinez1997-03-25

Teachers

TeacherIDFirstNameLastNameSubject
1Mr.GreenMathematics
2Ms.WhitePhysics
3Dr.BlackChemistry
4Prof.BrownBiology
5Mrs.HarrisEnglish

FieldTrips

TripIDLocationDatePurpose
(→ Purposes.Purpose)
1New York City2023-05-15Real-world Application
2Washington DC2023-06-01Research Project

StudyGroups

GroupIDDescriptionLeaderID
(→ Teachers.TeacherID)
1A group focused on real-world applications of physics2
2A study group discussing chemistry concepts3

StudentsInGroups

StudentIDGroupID
(→ Students.StudentID)(→ StudyGroups.GroupID)
11
21
32
42

TripsAndGroups

TripIDGroupID
(→ FieldTrips.TripID)(→ StudyGroups.GroupID)
11
22

Purposes

PurposeIDPurpose
1Real-world Application
2Research Project
3Creative Writing
4Scientific Inquiry
5Technological Innovation