| 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 |
| 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 |
| 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 |
| 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 |
| 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_id | materials_id |
|---|---|
| (→ Teachers.id) | (→ Materials.id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 3 |
| 3 | 4 |
| 5 | 5 |