Teachers

idnamesubject
1John DoeMathematics
2Jane SmithEnglish Literature
3Emily JohnsonBiology
4Michael BrownPhysical Education
5Linda WhiteHistory

Materials

idmaterial_nametype
1Algebra I TextbookTextbook
2Geometry TextbookTextbook
3To Kill a Mockingbird NovelBook
4Cell Biology BookBook
5World War II History BookBook

Classes

idclass_nameteacher_id
(→ Teachers.id)
1Algebra I1
2Geometry2
3Biology3
4Physical Education4
5American History5

Students

idstudent_nameageclass_id
(→ Classes.id)
1Tom Lee161
2Jessica Kim171
3Mark Davis181
4Ashley Wilson191
5David Miller152

Assignments

idassignment_titledue_dateclass_id
(→ Classes.id)
1Homework 12022-09-011
2Quiz 12022-09-071
3Project 12022-09-211
4Test 12022-10-051
5Paper 12022-10-262

Teachers_Materials

teachers_idmaterials_id
(→ Teachers.id)(→ Materials.id)
11
12
23
34
55