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 |