| id | topic |
|---|---|
| 1 | Environmental Science |
| 2 | Mathematics |
| 3 | Physics |
| 4 | Chemistry |
| 5 | Biology |
| id | case_description | topic_id |
|---|---|---|
| (→ Topics.id) | ||
| 1 | A study of deforestation and its effects | 1 |
| 2 | An analysis of the impact of plastic pollution | 2 |
| 3 | Exploring alternative energy sources | 3 |
| 4 | The role of chemistry in climate change | 4 |
| 5 | Investigating the importance of biodiversity | 5 |
| id | interviewee | interview_date | topic_id |
|---|---|---|---|
| (→ Topics.id) | |||
| 1 | Dr. Jane Smith | 2022-06-08 10:00:00 | 1 |
| 2 | Dr. John Doe | 2022-07-12 14:00:00 | 2 |
| 3 | Prof. Alice Brown | 2022-08-15 09:00:00 | 3 |
| 4 | Dr. Bob Johnson | 2022-09-20 11:00:00 | 4 |
| 5 | Ms. Carol White | 2022-10-25 16:00:00 | 5 |
| id | student_name | major | case_study_id | interview_id |
|---|---|---|---|---|
| (→ Case_studies.id) | (→ Interviews.id) | |||
| 1 | Michael Johnson | Environmental Science | 1 | 1 |
| 2 | Emily Davis | Biology | 2 | 2 |
| 3 | James Wilson | Chemistry | 3 | 3 |
| 4 | Laura Martinez | Mathematics | 4 | 4 |
| 5 | David Rodriguez | Physics | 5 | 5 |
| id | teacher_name | subject | case_study_id | interview_id |
|---|---|---|---|---|
| (→ Case_studies.id) | (→ Interviews.id) | |||
| 1 | Mr. Mark Taylor | Environmental Science | 1 | 1 |
| 2 | Mrs. Susan Thompson | Physics | 2 | 2 |
| 3 | Mr. Charles Lee | Mathematics | 3 | 3 |
| 4 | Mrs. Linda Clark | Chemistry | 4 | 4 |
| 5 | Mr. Robert Miller | Biology | 5 | 5 |
| id | resource_type | resource_url | related_topic_id |
|---|---|---|---|
| (→ Topics.id) | |||
| 1 | Article | https://www.example.com/defor... | 1 |
| 2 | Video | https://www.youtube.com/watch?v=aBcDeFgHiJ&list=PLmQwX... | 2 |
| 3 | Book | https://www.amazon.com/Green-R... | 3 |
| 4 | Podcast | https://podcasts.apple.com/us/p... | 4 |
| 5 | Website | https://www.earthday.org | 5 |