Newspapers

idnameeditor_in_chiefheadquarters
1The Daily ChronicleJane DoeNew York
2Metro NewsJohn SmithLondon

Magazines

idmagazine_namepublisher_namepublication_frequency
1Vanity FairCondé NastMonthly
2Time MagazineTime Inc.Weekly

Circulation_numbers

newspaper_idmagazine_idcirculation
(→ Newspapers.id)(→ Magazines.id)
1120000
2220000
1None30000
None240000

Articles

article_idtitlecontentauthorpublication_datenewspaper_idmagazine_id
(→ Newspapers.id)(→ Magazines.id)
1Article 1 TitleContent of article 1Author A2022-01-0111
2Article 2 TitleContent of article 2Author B2022-01-0221

Authors

author_idfirst_namelast_nameemail
1Author CLast Namec@example.com
2Author DLast Named@example.com

Article_Authors

article_idauthor_id
(→ Articles.article_id)(→ Authors.author_id)
11
22