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 |