## News_Agencies

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

## Departments

department_id | department_name
--- | ---
1 | Foreign_Correspondence
2 | Politics
3 | Economy
4 | Technology
5 | Culture

## News_Agencies_Departments

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