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 |