JobRoles

idJob_TitleNewsAgencyID
1Public Relations1
2Public Relations2
3Government Communications1
4Government Communications2
5Editorial Director3

NewsAgencies

idContacts
1Contact1@bbc.com
2Contact2@abcnews.com
3Contact3@nytimes.com

Articles

ArticleIdTitleContentPublishDateAuthorIDAgencyID
(→ Journalists.id)(→ NewsAgencies.id)
1Article1Content of article 1...2022-07-01 10:00:0011
2Article2Content of article 2...2022-07-02 10:00:0022
3Article3Content of article 3...2022-07-03 10:00:0031

Journalists

idNameContactRoleIDArticleID
(→ JobRoles.id)(→ Articles.ArticleId)
1John Doejohn.doe@example.com11
2Jane Smithjane.smith@example.com22
3Michael Johnsonmichael.johnson@example.com33