| authorID | firstName | lastName | |
|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |