## Subjects

id | subjectName
--- | ---
1 | Mathematics
2 | Physics
3 | Chemistry
4 | Biology
5 | History

## Teachers

teacherId | firstName | lastName | email
--- | --- | --- | ---
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

## Classes

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

## Students

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

## Learning_Materials

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

## Difficulty_levels

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.