Magazines

idnamepublication_dateeditor_name
1The Daily Times2021-06-01John Smith
2Weekly News Digest2021-07-01Jane Doe
3Monthly Business Review2021-08-01Tom Brown
4Technology Insider2021-09-01Emily White
5Fashion World2021-10-01Michael Black

Columns

idcolumn_name
1Editor's Letter
2Feature Story
3Opinion Piece
4Book Reviews
5Travel Guide

Authors

idfirst_namelast_nameemail
1AlexSmithalex@gmail.com
2LindaDoelinda@yahoo.com
3RobertBrownrobert@hotmail.com
4CathyWhitecathy@aol.com
5DavidBlackdavid@protonmail.com

Articles

idtitlecontentpublish_datemagazine_idauthor_id
(→ Magazines.id)(→ Authors.id)
1First Article TitleContent of First Article...2021-06-0111
2Second Article TitleContent of Second Article...2021-06-0312
3Third Article TitleContent of Third Article...2021-06-0523
4Fourth Article TitleContent of Fourth Article...2021-06-0724
5Fifth Article TitleContent of Fifth Article...2021-06-0925

Magazine_Authors

magazine_idauthor_id
(→ Magazines.id)(→ Authors.id)
11
12
23
24
35

Magazines_Columns

magazine_idcolumn_idissue_date
(→ Magazines.id)(→ Columns.id)
112021-06-01
122021-06-01
212021-07-01
222021-07-01
312021-08-01
322021-08-01
41None
51None