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 |