## Newspapers

ID | Name | Circulation_Numbers | Founded_Year | Headquarters | Editor_in_Chief
--- | --- | --- | --- | --- | ---
1 | The Guardian | 20000 | 1959 | London, UK | Katharine Viner
2 | Le Monde | 30000 | 1944 | Paris, France | Jacques Maurer
3 | El País | 25000 | 1976 | Madrid, Spain | Carol Glatz
4 | The Hindu | 18000 | 1878 | Chennai, India | N. Ram
5 | South China Morning Post | 17000 | 1903 | Hong Kong, China | Paula Ma

## Magazines

ID | Name | Circulation_Numbers | Issue_Frequency | Publisher | Topic
--- | --- | --- | --- | --- | ---
1 | National Geographic | 50000 | Monthly | National Geographic Society | Travel & Adventure
2 | Time | 30000 | Weekly | Meredith Corporation | Current Affairs & World News
3 | Scientific American | 20000 | Biweekly | Springer Nature | Science & Technology
4 | Wired | 25000 | Monthly | Condé Nast | Technology & Culture
5 | Vanity Fair | 20000 | Monthly | Conde Nast | Entertainment & Lifestyle

## Articles

Article_ID | Title | Publication_Date | Content_Length | Author_Name | Newspaper_ID | Magazine_ID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Newspapers.ID) | (→ Magazines.ID)
1 | Climate Change is Real | 2021-01-01 | 1500 | John Smith | 1 | None
2 | The Rise of AI Technologies | 2021-02-15 | 1800 | Emma Johnson | None | 2
3 | Exploring Mars with NASA Rovers | 2021-03-20 | 1200 | David Brown | 3 | None
4 | Inside the Minds of Great Leaders | 2021-04-10 | 1600 | Linda Lee | None | 4
5 | The Impact of Social Media on Mental Health | 2021-05-01 | 1400 | Christopher Green | 5 | None

## Authors

Author_ID | First_Name | Last_Name | Biography | Email
--- | --- | --- | --- | ---
1 | John | Doe | An award winning journalist with over 20 years of experience. | john.doe@example.com
2 | Emma | Smith | A seasoned writer who has covered a wide range of topics. | emma.smith@example.com
3 | David | Brown | With expertise in science journalism, David brings a unique perspective to his work. | david.brown@example.com
4 | Linda | Lee | As an investigative reporter, Linda has uncovered many important stories throughout her career. | linda.lee@example.com
5 | Christopher | Green | His insightful articles have made him a respected voice in mental health reporting. | christopher.green@example.com

## Subscriptions

Subscription_ID | Customer_Name | Address | Phone_Number | Subscribed_To | Start_Date | End_Date
--- | --- | --- | --- | --- | --- | ---
1 | John Doe | 123 Main St, Anytown USA | 555-123-4567 | Newspaper | 2021-01-01 | 2021-12-31
2 | Emma Smith | 456 Elm St, Anothertown USA | 555-987-6543 | Magazine | 2021-02-15 | 2021-12-31
3 | David Brown | 789 Oak St, Yet another town USA | 555-135-7890 | Newspaper | 2021-03-20 | 2021-12-31
4 | Linda Lee | 123 Pine St, Somewhere USA | 555-555-5555 | Magazine | 2021-04-10 | 2021-12-31
5 | Christopher Green | 456 Spruce St, Everytown USA | 555-777-8888 | Newspaper | 2021-05-01 | 2021-12-31