| id | Name | Publication_Frequency | Circulation_Size | Website_URL |
|---|---|---|---|---|
| 1 | The Daily Tribune | Daily | 100000 | www.dailytribune.com |
| 2 | The Weekender | Weekly | 80000 | www.theweekender.com |
| 3 | The Sunday Post | Weekly | 90000 | www.sundaypost.com |
| 4 | The Financial Times | Daily | 200000 | www.ft.com |
| 5 | The Economist | Weekly | 70000 | www.economist.com |
| id | Name | Publication_Frequency | Circulation_Size | Publisher |
|---|---|---|---|---|
| 1 | National Geographic | Monthly | 300000 | NatGeo Publishing |
| 2 | Time | Weekly | 250000 | Time Inc. |
| 3 | Forbes | Biweekly | 150000 | Forbes Media LLC |
| 4 | Wired | Monthly | 200000 | Condé Nast |
| 5 | Scientific American | Monthly | 60000 | Springer Nature |
| id | FirstName | LastName | PhoneNumber | |
|---|---|---|---|---|
| 1 | John | Smith | johnsmith@example.com | +1-555-123-4567 |
| 2 | Jane | Doe | janedoe@example.com | +1-555-987-6543 |
| 3 | Michael | Brown | michaelbrown@example.com | +1-555-456-7890 |
| 4 | Emily | White | emilywhite@example.com | +1-555-111-2222 |
| 5 | David | Gray | davidgray@example.com | +1-555-333-4444 |
| id | Title | Content | Publish_Date | Magazine_id | NEWSPAPER_id |
|---|---|---|---|---|---|
| (→ Magazines.id) | (→ Newspapers.id) | ||||
| 1 | Climate Change Impact | A detailed analysis of climate change... | 2022-10-01 10:00:00 | 1 | None |
| 2 | Technology Trends | Exploring recent developments in technology... | 2022-10-02 10:00:00 | 2 | None |
| 3 | Economic Outlook | An overview of global economy trends... | 2022-10-03 10:00:00 | 3 | None |
| 4 | Investment Strategies | Key strategies for successful investing... | 2022-10-04 10:00:00 | 4 | None |
| 5 | Healthcare Innovations | Advancements in healthcare technologies... | 2022-10-05 10:00:00 | 5 | None |
| id | Category_name | Article_id | Journalist_id |
|---|---|---|---|
| (→ Articles.id) | (→ Journalists.id) | ||
| 1 | Environmental News | 1 | 1 |
| 2 | Business & Finance | 2 | 2 |
| 3 | World Affairs | 3 | 3 |
| 4 | Personal Finance | 4 | 4 |
| 5 | Medical Research | 5 | 5 |