## Distributor

ID | Name
--- | ---
1 | Sainsbury's
2 | Tesco

## NewspaperType

TypeID | TypeName
--- | ---
1 | Political Analysis
2 | Entertainment News
3 | Fashion Trends
4 | Technology Innovations
5 | Health Tips

## Broadsheet

NewspaperID | Title | Content | Price | DistributorID
--- | --- | --- | --- | ---
|  |  |  | (→ Distributor.ID)
1 | The Guardian | Latest news and analysis... | 1.2 | 1
2 | Financial Times | Business and financial news... | 3.0 | 1
3 | Independent | News and opinion articles... | 1.5 | 2
4 | Telegraph | Current affairs and commentary... | 2.0 | 2
5 | Times | UK and world news updates... | 3.5 | 1

## Tabloid

NewspaperID | Title | Content | Price | DistributorID
--- | --- | --- | --- | ---
|  |  |  | (→ Distributor.ID)
1 | Sun | Celebrity gossip and sports... | 0.8 | 1
2 | Mirror | General interest stories and showbiz news... | 0.6 | 1
3 | Express | Conservative politics and news... | 0.9 | 2
4 | Star | Showbiz, entertainment, and celebrity news... | 0.7 | 2
5 | Mail | General news with conservative bias... | 0.95 | 2

## Article

ArticleID | Headline | Body | DatePublished | AuthorID | NewspaperTypeID
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Authors.ID) | (→ NewspaperType.TypeID)
1 | Economic Growth Boosts UK Markets | Investment in technology drives growth... | 2024-03-13 21:21:53 | 1 | 1
2 | Royal Wedding Coverage | All the latest details on the royal wedding... | 2024-03-13 21:21:53 | 2 | 3
3 | Apple Unveils New iPhone Model | Features, specifications, and pricing information... | 2024-03-13 21:21:53 | 3 | 4
4 | Vaccine Development Progress | Update on COVID-19 vaccine development... | 2024-03-13 21:21:53 | 4 | 5
5 | Obesity Epidemic in Children | Growing concern over childhood obesity rates... | 2024-03-13 21:21:53 | 5 | 2

## Authors

ID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Smith | johnsmith@email.com
2 | Jane | Doe | janedoe@email.com
3 | Michael | Brown | michaelbrown@email.com
4 | Emily | White | emilywhite@email.com
5 | David | Black | davidblack@email.com