Student

IDFirstNameLastNameAgeGradeLevel
1JohnDoe1610
2JaneSmith1712
3EmmaBrown1811
4MichaelJohnson1910
5OliviaWilliams169

Course

IDTitleSubjectTeacherID
(→ Teacher.ID)
1Algebra IMathematics1
2PhysicsScience2
3English LiteratureLanguage Arts3
4World HistoryHistory4
5Art AppreciationFine Arts5

LearningActivity

IDDescriptionActivityTypePurposeID
(→ Purpose.ID)
1Visit a local museumField Trip1
2Visit a science centerField Trip2
3Organize a group projectStudy Group1
4Host a debate on current eventsStudy Group2

Purpose

IDName
1Real-world Application
2Problem Solving Skills Development

Teacher

IDFirstNameLastNameDepartment
1Mr.WhiteMathematics
2Ms.GreenScience
3Dr.BlackLanguage Arts
4Mrs.BlueHistory
5Ms.RedFine Arts

Enrollment

StudentIDCourseIDDateEnrolledGrades
(→ Student.ID)(→ Course.ID)
112022-09-0185
222022-09-0190
332022-09-0180
442022-09-0175
552022-09-0195