Managing_Editor

idnameemail
1John Doejohn@example.com
2Jane Smithjane@example.com

Copy_Editor

idnameemail
1Mike Johnsonmike@example.com
2Emily Davisemily@example.com

Final_Draft

idmanaging_editor_idcopy_editor_id
(→ Managing_Editor.id)(→ Copy_Editor.id)
111
222

Articles

idtitlecontentauthor_idreporter_idfinal_draft_id
(→ Authors.author_id)(→ Reporters.reporter_id)(→ Final_Draft.id)
1Breaking News StoryThis is a news story about breaking news.111
2Feature on Local BusinessA feature article about a local business.222

Authors

author_idfirstnamelastname
1AliceBrown
2CharlieGreen

Reporters

reporter_idfirstnamelastname
1DavidBlack
2EvaWhite