| id | name | location | established_year |
|---|---|---|---|
| 1 | Agency1 | USA | 2008 |
| 2 | Agency2 | UK | 1996 |
| 3 | Agency3 | India | 2010 |
| 4 | Agency4 | Australia | 2000 |
| 5 | Agency5 | Germany | 2007 |
| department_id | department_name |
|---|---|
| 1 | Foreign_Correspondence |
| 2 | Politics |
| 3 | Economy |
| 4 | Technology |
| 5 | Culture |
| agency_id | department_id |
|---|---|
| (→ News_Agencies.id) | (→ Departments.department_id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 3 |
| 2 | 4 |
| 3 | 5 |
| 3 | 2 |
| 4 | 3 |
| 4 | 4 |
| 5 | 1 |
| 5 | 2 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |