Magazines

idnameurl
1The New Yorkerhttps://www.newyorker.com/
2Time Magazinehttp://time.com/

Social_Media

idmagazine_idplatformfollowers
(→ Magazines.id)
11Twitter2000000
22Instagram3000000

Email_Newsletters

idmagazine_idsubscribersfrequency
(→ Magazines.id)
11100000Weekly
2280000Biweekly

Authors

idnameemail
1John Doejohndoe@example.com
2Jane Smithjanesmith@example.com

Articles

idtitlecontentauthor_idmagazine_idpublication_date
(→ Authors.id)(→ Magazines.id)
1Article Title 1Content of Article 1...112021-07-01
2Article Title 2Content of Article 2...212021-07-02
3Article Title 3Content of Article 3...122021-07-03
4Article Title 4Content of Article 4...222021-07-04
5Article Title 5Content of Article 5...112021-07-05