FieldTrips

tripIDfieldTrippurposelocationdate
1Engineering PlantReal-world ApplicationNew York City2022-09-15 10:00:00
2Marine Biology ExpeditionEducationalCaribbean Sea2022-08-20 07:00:00

StudyGroups

groupIDstudyGroupNamepurposeleaderNamemeetingDate
1Data Science GroupReal-world ApplicationJohn Smith2022-06-15 18:00:00
2Mathematics ClubRecreationalJane Doe2022-07-05 19:00:00

Students

studentIDfirstNamelastNamebirthdateemailAddress
1AliceSmith2000-05-10alice.smith@example.com
2BobJohnson1998-03-15bob.johnson@example.com

Teachers

teacherIDfirstNamelastNamebirthdateemailAddress
1Mr.Doe1975-07-01mr.doe@example.com
2Ms.White1972-10-10ms.white@example.com

Enrollments

enrollmentIDcourseIdstudentIdgrade
(→ Courses.courseId)(→ Students.studentId)
11190.5
22288

CourseMaterials

materialIdcourseIdtitledescriptionformatdueDate
(→ Courses.courseId)
11Python ProgrammingLearn Python programming basicsPDF2022-09-20
21Advanced MathMaster advanced mathematical conceptsVideo2022-09-25