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 |