| 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. |