## Newspapers

id | name | editor_in_chief | headquarters
--- | --- | --- | ---
1 | The Daily Chronicle | Jane Doe | New York
2 | Metro News | John Smith | London

## Magazines

id | magazine_name | publisher_name | publication_frequency
--- | --- | --- | ---
1 | Vanity Fair | Condé Nast | Monthly
2 | Time Magazine | Time Inc. | Weekly

## Circulation_numbers

newspaper_id | magazine_id | circulation
--- | --- | ---
(→ Newspapers.id) | (→ Magazines.id) |
1 | 1 | 20000
2 | 2 | 20000
1 | None | 30000
None | 2 | 40000

## Articles

article_id | title | content | author | publication_date | newspaper_id | magazine_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Newspapers.id) | (→ Magazines.id)
1 | Article 1 Title | Content of article 1 | Author A | 2022-01-01 | 1 | 1
2 | Article 2 Title | Content of article 2 | Author B | 2022-01-02 | 2 | 1

## Authors

author_id | first_name | last_name | email
--- | --- | --- | ---
1 | Author C | Last Name | c@example.com
2 | Author D | Last Name | d@example.com

## Article_Authors

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