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 |