Distributor

IDName
1Sainsbury's
2Tesco

NewspaperType

TypeIDTypeName
1Political Analysis
2Entertainment News
3Fashion Trends
4Technology Innovations
5Health Tips

Broadsheet

NewspaperIDTitleContentPriceDistributorID
(→ Distributor.ID)
1The GuardianLatest news and analysis...1.21
2Financial TimesBusiness and financial news...3.01
3IndependentNews and opinion articles...1.52
4TelegraphCurrent affairs and commentary...2.02
5TimesUK and world news updates...3.51

Tabloid

NewspaperIDTitleContentPriceDistributorID
(→ Distributor.ID)
1SunCelebrity gossip and sports...0.81
2MirrorGeneral interest stories and showbiz news...0.61
3ExpressConservative politics and news...0.92
4StarShowbiz, entertainment, and celebrity news...0.72
5MailGeneral news with conservative bias...0.952

Article

ArticleIDHeadlineBodyDatePublishedAuthorIDNewspaperTypeID
(→ Authors.ID)(→ NewspaperType.TypeID)
1Economic Growth Boosts UK MarketsInvestment in technology drives growth...2024-03-13 21:21:5311
2Royal Wedding CoverageAll the latest details on the royal wedding...2024-03-13 21:21:5323
3Apple Unveils New iPhone ModelFeatures, specifications, and pricing information...2024-03-13 21:21:5334
4Vaccine Development ProgressUpdate on COVID-19 vaccine development...2024-03-13 21:21:5345
5Obesity Epidemic in ChildrenGrowing concern over childhood obesity rates...2024-03-13 21:21:5352

Authors

IDFirstNameLastNameEmail
1JohnSmithjohnsmith@email.com
2JaneDoejanedoe@email.com
3MichaelBrownmichaelbrown@email.com
4EmilyWhiteemilywhite@email.com
5DavidBlackdavidblack@email.com