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 |