## Topics

id | topic
--- | ---
1 | Environmental Science
2 | Mathematics
3 | Physics
4 | Chemistry
5 | Biology

## Case_studies

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

## Interviews

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

## Students

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

## Teachers

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

## Resources

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