Students

idnameagemajor
1John Doe20Journalism
2Jane Smith23Mass Communication
3Michael Johnson22Media Studies
4Emma Brown21Broadcast Journalism
5Anne Smith24Print Journalism

NewsArticles

idtitlecontentstructurepublished_datestudent_name
(→ Students.name)
1First Article TitleContent of first article...Inverted Pyramid2022-01-01Anne Smith
2Second Article TitleContent of second article...Inverted Pyramid2022-01-02Michael Johnson
3Third Article TitleContent of third article...Chronological Structure2022-01-03Anne Smith
4Fourth Article TitleContent of fourth article...Chronological Structure2022-01-04Emma Brown
5Fifth Article TitleContent of fifth article...Inverted Pyramid2022-01-05John Doe

ArticleCategories

category_idcategory_name
1Politics
2Economy
3Technology
4Entertainment
5Sports

ArticlesByCategory

article_idcategory_id
(→ NewsArticles.id)(→ ArticleCategories.category_id)
11
22
33
44
55

Sources

source_idsource_nameurl
1The Guardianhttps://www.theguardian.com/
2BBC Newshttps://www.bbc.co.uk/news
3Al Jazeerahttps://www.aljazeera.com/
4Reutershttps://www.reuters.com/
5The New York Timeshttps://www.nytimes.com/

ArticlesWithSources

article_idsource_id
(→ NewsArticles.id)(→ Sources.source_id)
11
22
33
44
55