## Authors

authorID | firstName | lastName | email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Michael | Brown | michael.brown@example.com
4 | Emily | White | emily.white@example.com
5 | David | Green | david.green@example.com

## Articles

articleID | title | content | publishDate | authorID
--- | --- | --- | --- | ---
|  |  |  | (→ Authors.authorID)
1 | The Importance of Investigative Journalism | A deep dive into how investigative journalism can uncover corruption and hold power accountable. | 2023-01-01 | 1
2 | The Future of Digital Media | How digital media is changing the landscape of modern journalism. | 2023-01-15 | 2
3 | Fact-Checking in a Post-Truth World | Exploring the role of fact-checkers in an era where misinformation spreads like wildfire. | 2023-01-22 | 3
4 | Journalistic Ethics: A Code of Conduct | Understanding the ethical standards that journalists must adhere to. | 2023-01-29 | 4
5 | Censorship and Freedom of the Press | A discussion on the challenges faced by journalists in countries with limited press freedom. | 2023-02-05 | 5

## Magazines

magazineID | name | publisher | ISSN
--- | --- | --- | ---
1 | World News Weekly | Global Publishing House | 978-3-16-148410-0
2 | Investigate This! | Journalism Watchdog Association | 978-3-16-148411-7
3 | Digital Frontiers | Tech Innovators Network | 978-3-16-148412-4
4 | Ethical Matters | Media Standards Council | 978-3-16-148413-1
5 | Press Freedoms International | Freedom Advocacy Group | 978-3-16-148414-8

## MagazineArticles

magazineArticleID | articleID | magazineID | publicationMonth | publicationYear
--- | --- | --- | --- | ---
| (→ Articles.articleID) | (→ Magazines.magazineID) |  |
1 | 1 | 1 | 1 | 2023
2 | 2 | 1 | 2 | 2023
3 | 3 | 2 | 1 | 2023
4 | 4 | 2 | 2 | 2023
5 | 5 | 3 | 1 | 2023

## Subscriptions

subscriptionID | customerName | customerEmail | startDate | endDate | magazineID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Magazines.magazineID)
1 | Alice Johnson | alice.johnson@example.com | 2023-01-01 | 2023-12-31 | 1
2 | Bob Smith | bob.smith@example.com | 2023-01-15 | 2023-12-31 | 2
3 | Carol Brown | carol.brown@example.com | 2023-01-22 | 2023-12-31 | 3
4 | Daniel Green | daniel.green@example.com | 2023-01-29 | 2023-12-31 | 4
5 | Emma White | emma.white@example.com | 2023-02-05 | 2023-12-31 | 5

## Demographics

demographicID | Audience | magazineID
--- | --- | ---
|  | (→ Magazines.magazineID)
1 | General Readership | 1
2 | Technology Enthusiasts | 2
3 | Current Affairs | 3
4 | Ethics Focused | 4
5 | International Relations | 5