id | subjectName |
---|---|
1 | Mathematics |
2 | Physics |
3 | Chemistry |
4 | Biology |
5 | History |
teacherId | firstName | lastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Michael | Johnson | michael.johnson@example.com |
4 | Emily | Williams | emily.williams@example.com |
5 | David | Brown | david.brown@example.com |
classId | className | startDate | endDate | teacherId |
---|---|---|---|---|
(→ Teachers.teacherId) | ||||
1 | Math101 | 2023-09-01 | 2023-12-21 | 1 |
2 | Physics101 | 2023-08-30 | 2023-12-20 | 2 |
3 | Chemistry101 | 2023-09-01 | 2023-12-21 | 3 |
4 | Biology101 | 2023-08-30 | 2023-12-20 | 4 |
5 | History101 | 2023-09-01 | 2023-12-21 | 5 |
studentId | firstName | lastName | enrollmentYear | classId |
---|---|---|---|---|
(→ Classes.classId) | ||||
1 | Alice | Ward | 2023 | 1 |
2 | Bob | Green | 2023 | 2 |
3 | Charlie | Black | 2023 | 3 |
4 | David | White | 2023 | 4 |
5 | Eva | Gray | 2023 | 5 |
materialId | typeOfMaterial | title | description | difficultyLevel |
---|---|---|---|---|
(→ Difficulty_levels.difficultyLevel) | ||||
1 | Textbook | Introduction to Mathematics | A comprehensive textbook covering basic mathematics concepts. | Intermediate |
2 | Textbook | General Chemistry | An introductory chemistry textbook suitable for college students. | Beginner |
3 | Online Course | Advanced Physics | A detailed online course covering advanced physics topics. | Advanced |
4 | Online Course | World History I | An interactive online course exploring world history up to 1500 AD. | Intermediate |
difficultyLevel | levelDescription |
---|---|
Beginner | For beginners with little or no prior knowledge. |
Intermediate | For those who have a good understanding of the basics. |
Advanced | For experienced learners looking for challenging content. |