Website

idnameurl
1CNNhttps://www.cnn.com
2BBChttps://www.bbc.co.uk
3The Guardianhttps://www.theguardian.com
4Al Jazeerahttps://www.aljazeera.com
5New York Timeshttps://www.nytimes.com

Mobile_App

idname
1CNN App
2BBC App
3Guardian App
4Al Jazeera App
5NYT App

News_Agency

idnamewebsiteIdmobileAppId
(→ Website.id)(→ Mobile_App.id)
1CNN11
2BBC22
3The Guardian33
4Al Jazeera44
5New York Times55

Article

idtitlecontentpublishedDatenewsAgencyId
(→ News_Agency.id)
1Test Article 1This is a test article.2024-02-19 14:31:131
2Test Article 2Another test article.2024-02-19 14:31:132
3Test Article 3Yet another test article.2024-02-19 14:31:133
4Test Article 4And here is one more test article.2024-02-19 14:31:134
5Test Article 5Last but not least, a test article!2024-02-19 14:31:135

Author

idfirstNamelastName
1JohnDoe
2JaneSmith
3MichaelJohnson
4EmilyWilliams
5DavidBrown

AuthorArticle

authorIdarticleId
(→ Author.id)(→ Article.id)
11
22
33
44
55