| ID | Name |
|---|---|
| 1 | Sainsbury's |
| 2 | Tesco |
| TypeID | TypeName |
|---|---|
| 1 | Political Analysis |
| 2 | Entertainment News |
| 3 | Fashion Trends |
| 4 | Technology Innovations |
| 5 | Health Tips |
| 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 |
| 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 | General news with conservative bias... | 0.95 | 2 |
| 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 |
| ID | FirstName | LastName | |
|---|---|---|---|
| 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 |