## Teachers

id | name | subject
--- | --- | ---
1 | John Doe | Mathematics
2 | Jane Smith | English Literature
3 | Emily Johnson | Biology
4 | Michael Brown | Physical Education
5 | Linda White | History

## Materials

id | material_name | type
--- | --- | ---
1 | Algebra I Textbook | Textbook
2 | Geometry Textbook | Textbook
3 | To Kill a Mockingbird Novel | Book
4 | Cell Biology Book | Book
5 | World War II History Book | Book

## Classes

id | class_name | teacher_id
--- | --- | ---
|  | (→ Teachers.id)
1 | Algebra I | 1
2 | Geometry | 2
3 | Biology | 3
4 | Physical Education | 4
5 | American History | 5

## Students

id | student_name | age | class_id
--- | --- | --- | ---
|  |  | (→ Classes.id)
1 | Tom Lee | 16 | 1
2 | Jessica Kim | 17 | 1
3 | Mark Davis | 18 | 1
4 | Ashley Wilson | 19 | 1
5 | David Miller | 15 | 2

## Assignments

id | assignment_title | due_date | class_id
--- | --- | --- | ---
|  |  | (→ Classes.id)
1 | Homework 1 | 2022-09-01 | 1
2 | Quiz 1 | 2022-09-07 | 1
3 | Project 1 | 2022-09-21 | 1
4 | Test 1 | 2022-10-05 | 1
5 | Paper 1 | 2022-10-26 | 2

## Teachers_Materials

teachers_id | materials_id
--- | ---
(→ Teachers.id) | (→ Materials.id)
1 | 1
1 | 2
2 | 3
3 | 4
5 | 5