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 |