id | lessonName | teacherId |
---|---|---|
1 | Introduction to Math | 1 |
2 | Beginner English Grammar | 2 |
3 | Ancient History Timeline | 3 |
4 | Cell Structure and Function | 4 |
5 | Basics of Physics | 5 |
activityType | description |
---|---|
Group_Work | Collaborative learning task |
Individual_Project | Personal project assignment |
Quiz | Short test to assess understanding |
Lecture | Instructor-led presentation on a topic |
Discussion | Classwide conversation about a topic |
studentId | name | age |
---|---|---|
1 | Alice | 12 |
2 | Bob | 13 |
3 | Charlie | 14 |
4 | David | 15 |
5 | Eva | 16 |
teacherId | name | subject |
---|---|---|
1 | Mr. Smith | Math |
2 | Ms. Johnson | English |
3 | Mrs. Lee | History |
4 | Dr. Brown | Biology |
5 | Professor White | Physics |
enrollmentId | studentId | classId |
---|---|---|
(→ Students.studentId) | (→ Lessons.id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
lessonsActivityId | lessonsId | activitiesType |
---|---|---|
(→ Lessons.id) | (→ Activities.activityType) | |
1 | 1 | Group_Work |
2 | 1 | Quiz |
3 | 2 | Individual_Project |
4 | 2 | Lecture |
5 | 3 | Quiz |
6 | 2 | Quiz |
7 | 4 | Quiz |
8 | 5 | Quiz |