| 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 |
| TeacherID | FirstName | LastName | Subject |
|---|---|---|---|
| 1 | Mr. | Green | Mathematics |
| 2 | Ms. | White | Physics |
| 3 | Dr. | Black | Chemistry |
| 4 | Prof. | Brown | Biology |
| 5 | Mrs. | Harris | English |
| TripID | Location | Date | Purpose |
|---|---|---|---|
| (→ Purposes.Purpose) | |||
| 1 | New York City | 2023-05-15 | Real-world Application |
| 2 | Washington DC | 2023-06-01 | Research Project |
| GroupID | Description | LeaderID |
|---|---|---|
| (→ Teachers.TeacherID) | ||
| 1 | A group focused on real-world applications of physics | 2 |
| 2 | A study group discussing chemistry concepts | 3 |
| StudentID | GroupID |
|---|---|
| (→ Students.StudentID) | (→ StudyGroups.GroupID) |
| 1 | 1 |
| 2 | 1 |
| 3 | 2 |
| 4 | 2 |
| TripID | GroupID |
|---|---|
| (→ FieldTrips.TripID) | (→ StudyGroups.GroupID) |
| 1 | 1 |
| 2 | 2 |
| PurposeID | Purpose |
|---|---|
| 1 | Real-world Application |
| 2 | Research Project |
| 3 | Creative Writing |
| 4 | Scientific Inquiry |
| 5 | Technological Innovation |