Newspapers

idnamefrequencylanguageissue_dateformat_type
(→ Newspaper_Formats.id)
1The Daily PostDailyEnglish2023-01-011
2Financial TimesWeeklyEnglish2023-01-062

Newspaper_Formats

idformat_name
1Broadsheet
2Tabloid

Articles

idtitlecontentpublish_datenewspaper_id
(→ Newspapers.id)
1First ArticleThis is the first article.2023-01-01 10:00:001
2Second ArticleThis is the second article.2023-01-07 10:00:002

Authors

idfirst_namelast_nameemail
1JohnSmithjohnsmith@example.com
2JaneDoejanedoe@example.com
3MichaelBrownmikebrown@example.com
4EmilyWhiteemwhite@example.com

Author_Articles

article_idauthor_id
(→ Articles.id)(→ Authors.id)
11
22
33
44

Distributors

idcompany_namelocation
1Sainsbury'sLondon
2TescoManchester

Distribution

newspaper_iddistributor_idquantity
(→ Newspapers.id)(→ Distributors.id)
111000
21800
12900
22700