Reporters

idnamebirthDateemail
1John Doe1987-06-13john@example.com
2Jane Smith1990-03-18jane@example.com

Articles

idtitlecontentpublishDatereporterIdcategoryId
(→ Reporters.id)(→ Categories.id)
1Article Title 1Content of article 12021-07-0111
2Article Title 2Content of article 22021-07-0222

Categories

idname
1Politics
2Economy
3Technology

Awards

idawardNameyear
1Pulitzer Prize2010
2Pulitzer Prize2011
3George Polk Award2010
4George Polk Award2012

Reporter_Awards

reporterIdawardId
(→ Reporters.id)(→ Awards.id)
11
22