## JobRoles

id | Job_Title | NewsAgencyID
--- | --- | ---
1 | Public Relations | 1
2 | Public Relations | 2
3 | Government Communications | 1
4 | Government Communications | 2
5 | Editorial Director | 3

## NewsAgencies

id | Contacts
--- | ---
1 | Contact1@bbc.com
2 | Contact2@abcnews.com
3 | Contact3@nytimes.com

## Articles

ArticleId | Title | Content | PublishDate | AuthorID | AgencyID
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Journalists.id) | (→ NewsAgencies.id)
1 | Article1 | Content of article 1... | 2022-07-01 10:00:00 | 1 | 1
2 | Article2 | Content of article 2... | 2022-07-02 10:00:00 | 2 | 2
3 | Article3 | Content of article 3... | 2022-07-03 10:00:00 | 3 | 1

## Journalists

id | Name | Contact | RoleID | ArticleID
--- | --- | --- | --- | ---
|  |  | (→ JobRoles.id) | (→ Articles.ArticleId)
1 | John Doe | john.doe@example.com | 1 | 1
2 | Jane Smith | jane.smith@example.com | 2 | 2
3 | Michael Johnson | michael.johnson@example.com | 3 | 3