## Students

StudentID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2003-01-15
2 | Jane | Smith | 2002-06-28
3 | Alice | Johnson | 2000-11-12
4 | Michael | Williams | 1999-07-20
5 | Emma | Martinez | 1997-03-25

## Teachers

TeacherID | FirstName | LastName | Subject
--- | --- | --- | ---
1 | Mr. | Green | Mathematics
2 | Ms. | White | Physics
3 | Dr. | Black | Chemistry
4 | Prof. | Brown | Biology
5 | Mrs. | Harris | English

## FieldTrips

TripID | Location | Date | Purpose
--- | --- | --- | ---
|  |  | (→ Purposes.Purpose)
1 | New York City | 2023-05-15 | Real-world Application
2 | Washington DC | 2023-06-01 | Research Project

## StudyGroups

GroupID | Description | LeaderID
--- | --- | ---
|  | (→ Teachers.TeacherID)
1 | A group focused on real-world applications of physics | 2
2 | A study group discussing chemistry concepts | 3

## StudentsInGroups

StudentID | GroupID
--- | ---
(→ Students.StudentID) | (→ StudyGroups.GroupID)
1 | 1
2 | 1
3 | 2
4 | 2

## TripsAndGroups

TripID | GroupID
--- | ---
(→ FieldTrips.TripID) | (→ StudyGroups.GroupID)
1 | 1
2 | 2

## Purposes

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