Lessons

idlessonNameteacherId
1Introduction to Math1
2Beginner English Grammar2
3Ancient History Timeline3
4Cell Structure and Function4
5Basics of Physics5

Activities

activityTypedescription
Group_WorkCollaborative learning task
Individual_ProjectPersonal project assignment
QuizShort test to assess understanding
LectureInstructor-led presentation on a topic
DiscussionClasswide conversation about a topic

Students

studentIdnameage
1Alice12
2Bob13
3Charlie14
4David15
5Eva16

Teachers

teacherIdnamesubject
1Mr. SmithMath
2Ms. JohnsonEnglish
3Mrs. LeeHistory
4Dr. BrownBiology
5Professor WhitePhysics

Enrollments

enrollmentIdstudentIdclassId
(→ Students.studentId)(→ Lessons.id)
111
222
333
444
555

Lessons_Activities

lessonsActivityIdlessonsIdactivitiesType
(→ Lessons.id)(→ Activities.activityType)
11Group_Work
21Quiz
32Individual_Project
42Lecture
53Quiz
62Quiz
74Quiz
85Quiz