Distributor

IDName
1Sainsbury's
2Tesco

Newspaper_Type

IDTypeDescription
1BroadsheetA type of newspaper that is larger than a tabloid.
2TabloidA type of newspaper that is smaller than a broadsheet.

Broadsheet_Newspapers

IDNameDistributorId
(→ Distributor.ID)
1The Times1
2Financial Times1
3The Guardian2
4The Independent2
5The Daily Telegraph1

Tabloid_Newspapers

IDNameDistributorId
(→ Distributor.ID)
1The Sun1
2The Mirror1
3Daily Mail2
4The Express2
5The Star1

Articles

ArticleIdTitleContentDateOfPublicationNewspaperId
(→ Newspaper_Type.ID)
1Political Crisis AheadAnalysis on the political crisis in the country.2021-08-011
2Investment Market BoomsDiscussion about recent boom in investment market.2021-07-292
3Climate Change SummitReporting on climate change summit held recently.2021-06-123
4Olympics Opening CeremonyReview of opening ceremony at Tokyo Olympics.2021-07-234
5Pandemic UpdateLatest update on COVID pandemic situation.2021-08-055

Authors

AuthorIdFullNameBiography
1John SmithJohn has been writing since his college years.
2Jane DoeJane works as a freelance journalist covering politics.
3Tom BrownTom writes about business and economy issues.
4Emma WilsonEmma specializes in sports journalism.
5Michael JohnsonMichael covers world events and international relations.

Authored_Articles

ArticleIdAuthorId
(→ Articles.ArticleId)(→ Authors.AuthorId)
11
22
33
44
55