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 |
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 |
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 |
Author_ID | First_Name | Last_Name | Biography | |
---|---|---|---|---|
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 |
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 |