| 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 |
| 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 |
| 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 |
| 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 |
| enrollmentID | courseId | studentId | grade |
|---|---|---|---|
| (→ Courses.courseId) | (→ Students.studentId) | ||
| 1 | 1 | 1 | 90.5 |
| 2 | 2 | 2 | 88 |
| materialId | courseId | title | description | format | dueDate |
|---|---|---|---|---|---|
| (→ Courses.courseId) | |||||
| 1 | 1 | Python Programming | Learn Python programming basics | 2022-09-20 | |
| 2 | 1 | Advanced Math | Master advanced mathematical concepts | Video | 2022-09-25 |