## Newspapers

id | name | frequency | language | issue_date | format_type
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Newspaper_Formats.id)
1 | The Daily Post | Daily | English | 2023-01-01 | 1
2 | Financial Times | Weekly | English | 2023-01-06 | 2

## Newspaper_Formats

id | format_name
--- | ---
1 | Broadsheet
2 | Tabloid

## Articles

id | title | content | publish_date | newspaper_id
--- | --- | --- | --- | ---
|  |  |  | (→ Newspapers.id)
1 | First Article | This is the first article. | 2023-01-01 10:00:00 | 1
2 | Second Article | This is the second article. | 2023-01-07 10:00:00 | 2

## Authors

id | first_name | last_name | email
--- | --- | --- | ---
1 | John | Smith | johnsmith@example.com
2 | Jane | Doe | janedoe@example.com
3 | Michael | Brown | mikebrown@example.com
4 | Emily | White | emwhite@example.com

## Author_Articles

article_id | author_id
--- | ---
(→ Articles.id) | (→ Authors.id)
1 | 1
2 | 2
3 | 3
4 | 4

## Distributors

id | company_name | location
--- | --- | ---
1 | Sainsbury's | London
2 | Tesco | Manchester

## Distribution

newspaper_id | distributor_id | quantity
--- | --- | ---
(→ Newspapers.id) | (→ Distributors.id) |
1 | 1 | 1000
2 | 1 | 800
1 | 2 | 900
2 | 2 | 700