Subjects

idsubjectName
1Mathematics
2Physics
3Chemistry
4Biology
5History

Teachers

teacherIdfirstNamelastNameemail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3MichaelJohnsonmichael.johnson@example.com
4EmilyWilliamsemily.williams@example.com
5DavidBrowndavid.brown@example.com

Classes

classIdclassNamestartDateendDateteacherId
(→ Teachers.teacherId)
1Math1012023-09-012023-12-211
2Physics1012023-08-302023-12-202
3Chemistry1012023-09-012023-12-213
4Biology1012023-08-302023-12-204
5History1012023-09-012023-12-215

Students

studentIdfirstNamelastNameenrollmentYearclassId
(→ Classes.classId)
1AliceWard20231
2BobGreen20232
3CharlieBlack20233
4DavidWhite20234
5EvaGray20235

Learning_Materials

materialIdtypeOfMaterialtitledescriptiondifficultyLevel
(→ Difficulty_levels.difficultyLevel)
1TextbookIntroduction to MathematicsA comprehensive textbook covering basic mathematics concepts.Intermediate
2TextbookGeneral ChemistryAn introductory chemistry textbook suitable for college students.Beginner
3Online CourseAdvanced PhysicsA detailed online course covering advanced physics topics.Advanced
4Online CourseWorld History IAn interactive online course exploring world history up to 1500 AD.Intermediate

Difficulty_levels

difficultyLevellevelDescription
BeginnerFor beginners with little or no prior knowledge.
IntermediateFor those who have a good understanding of the basics.
AdvancedFor experienced learners looking for challenging content.