## Newspapers

id | Name | Format | Distributor | FoundedDate
--- | --- | --- | --- | ---
|  |  | (→ Distributors.Name) |
1 | The Times | Broadsheet | Sainsbury's | 1785-01-01
2 | The Sun | Tabloid | Sainsbury's | 1964-03-17
3 | Mail on Sunday | Compact | Tesco | 1982-01-01
4 | Guardian Unlimited | Berliner | Tesco | 1999-01-01
5 | Financial Times | Tabloid | Direct delivery | 1888-01-01

## Distributors

id | Name | Address | PhoneNumber | EmailAddress
--- | --- | --- | --- | ---
1 | Sainsbury's | 123 High St | +44 1234567890 | distribution@sainburys.com
2 | Tesco | 456 Low St | +44 0987654321 | distribution@tesco.com

## Articles

id | Title | Content | PublicationDate | NewspaperId | AuthorId | CategoryId
--- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Newspapers.id) | (→ Authors.id) | (→ ArticleCategories.id)
1 | UK Election Results | Here are the results of the latest UK election. | 2021-10-01 | 2 | 1 | 1
2 | Stock Market Rises | The stock market experienced significant gains today. | 2021-10-01 | 3 | 2 | 2

## Authors

id | FirstName | LastName | Birthdate
--- | --- | --- | ---
1 | John | Smith | 1960-01-01
2 | Jane | Doe | 1975-05-01

## ArticleCategories

id | CategoryName | Description
--- | --- | ---
1 | Politics | News about governmental activities
2 | Economy | Business news and analysis