Topics

idtopic
1Environmental Science
2Mathematics
3Physics
4Chemistry
5Biology

Case_studies

idcase_descriptiontopic_id
(→ Topics.id)
1A study of deforestation and its effects1
2An analysis of the impact of plastic pollution2
3Exploring alternative energy sources3
4The role of chemistry in climate change4
5Investigating the importance of biodiversity5

Interviews

idintervieweeinterview_datetopic_id
(→ Topics.id)
1Dr. Jane Smith2022-06-08 10:00:001
2Dr. John Doe2022-07-12 14:00:002
3Prof. Alice Brown2022-08-15 09:00:003
4Dr. Bob Johnson2022-09-20 11:00:004
5Ms. Carol White2022-10-25 16:00:005

Students

idstudent_namemajorcase_study_idinterview_id
(→ Case_studies.id)(→ Interviews.id)
1Michael JohnsonEnvironmental Science11
2Emily DavisBiology22
3James WilsonChemistry33
4Laura MartinezMathematics44
5David RodriguezPhysics55

Teachers

idteacher_namesubjectcase_study_idinterview_id
(→ Case_studies.id)(→ Interviews.id)
1Mr. Mark TaylorEnvironmental Science11
2Mrs. Susan ThompsonPhysics22
3Mr. Charles LeeMathematics33
4Mrs. Linda ClarkChemistry44
5Mr. Robert MillerBiology55

Resources

idresource_typeresource_urlrelated_topic_id
(→ Topics.id)
1Articlehttps://www.example.com/defor...1
2Videohttps://www.youtube.com/watch?v=aBcDeFgHiJ&list=PLmQwX...2
3Bookhttps://www.amazon.com/Green-R...3
4Podcasthttps://podcasts.apple.com/us/p...4
5Websitehttps://www.earthday.org5