## FieldTrips

tripID | fieldTrip | purpose | location | date
--- | --- | --- | --- | ---
1 | Engineering Plant | Real-world Application | New York City | 2022-09-15 10:00:00
2 | Marine Biology Expedition | Educational | Caribbean Sea | 2022-08-20 07:00:00

## StudyGroups

groupID | studyGroupName | purpose | leaderName | meetingDate
--- | --- | --- | --- | ---
1 | Data Science Group | Real-world Application | John Smith | 2022-06-15 18:00:00
2 | Mathematics Club | Recreational | Jane Doe | 2022-07-05 19:00:00

## Students

studentID | firstName | lastName | birthdate | emailAddress
--- | --- | --- | --- | ---
1 | Alice | Smith | 2000-05-10 | alice.smith@example.com
2 | Bob | Johnson | 1998-03-15 | bob.johnson@example.com

## Teachers

teacherID | firstName | lastName | birthdate | emailAddress
--- | --- | --- | --- | ---
1 | Mr. | Doe | 1975-07-01 | mr.doe@example.com
2 | Ms. | White | 1972-10-10 | ms.white@example.com

## Enrollments

enrollmentID | courseId | studentId | grade
--- | --- | --- | ---
| (→ Courses.courseId) | (→ Students.studentId) |
1 | 1 | 1 | 90.5
2 | 2 | 2 | 88

## CourseMaterials

materialId | courseId | title | description | format | dueDate
--- | --- | --- | --- | --- | ---
| (→ Courses.courseId) |  |  |  |
1 | 1 | Python Programming | Learn Python programming basics | PDF | 2022-09-20
2 | 1 | Advanced Math | Master advanced mathematical concepts | Video | 2022-09-25