Authors

AuthorIDFirstNameLastNameBirthDate
1JohnDoe1980-06-01
2JaneSmith1975-03-15

Articles

ArticleIDTitlePublicationDateWordCountAuthorID
(→ Authors.AuthorID)
1Sample Article 12021-01-01 00:00:005001
2Sample Article 22021-02-01 00:00:007501

NewsOutlets

OutletIDNameLocationFoundedYear
1Newspaper ACity A1900
2Newspaper BCity B1950

Publishes

PublishIDArticleIDOutletID
(→ Articles.ArticleID)(→ NewsOutlets.OutletID)
111
222

Audience

DemoIDAge_GroupIncome_LevelArticle
(→ Articles.ArticleID)
125-34High1
235-44Medium2

Advertisements

AdvIDDescriptionBudgetStartDateEndDateOutletID
(→ NewsOutlets.OutletID)
1Advertisement 110002021-01-01 00:00:002021-01-31 23:59:591
2Advertisement 215002021-02-01 00:00:002021-02-28 23:59:592