| 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 |