ReporterID | FullName |
---|---|
1 | John Doe |
2 | Jane Smith |
3 | Michael Brown |
4 | Emily White |
5 | David Green |
IssueID | Name |
---|---|
1 | Climate_Change |
2 | Water_Pollution |
3 | Deforestation |
4 | Air_Quality |
5 | Wildlife_Conservation |
ArticleID | Title | Content | PublishedDate | Environmental_ReporterID |
---|---|---|---|---|
(→ Environmental_Reporters.ReporterID) | ||||
1 | Impact of Climate Change on Agriculture | This article discusses... | 2024-01-30 18:57:48 | 1 |
2 | The Rising Trends of Water Pollution | In this article we talk about... | 2024-01-30 18:57:48 | 2 |
3 | Effects of Deforestation on Biodiversity | Here we explore... | 2024-01-30 18:57:48 | 3 |
4 | Improving Air Quality in Urban Areas | This piece delves into... | 2024-01-30 18:57:48 | 4 |
5 | Protecting Endangered Species from Extinction | We investigate... | 2024-01-30 18:57:48 | 5 |
Environmental_Reporters_ID | Issues_ID |
---|---|
(→ Environmental_Reporters.ReporterID) | (→ Issues.IssueID) |
1 | 1 |
5 | 5 |
2 | 2 |
4 | 4 |
3 | 3 |