Newspapers

IDNameCirculation_NumbersFounded_YearHeadquartersEditor_in_Chief
1The Guardian200001959London, UKKatharine Viner
2Le Monde300001944Paris, FranceJacques Maurer
3El País250001976Madrid, SpainCarol Glatz
4The Hindu180001878Chennai, IndiaN. Ram
5South China Morning Post170001903Hong Kong, ChinaPaula Ma

Magazines

IDNameCirculation_NumbersIssue_FrequencyPublisherTopic
1National Geographic50000MonthlyNational Geographic SocietyTravel & Adventure
2Time30000WeeklyMeredith CorporationCurrent Affairs & World News
3Scientific American20000BiweeklySpringer NatureScience & Technology
4Wired25000MonthlyCondé NastTechnology & Culture
5Vanity Fair20000MonthlyConde NastEntertainment & Lifestyle

Articles

Article_IDTitlePublication_DateContent_LengthAuthor_NameNewspaper_IDMagazine_ID
(→ Newspapers.ID)(→ Magazines.ID)
1Climate Change is Real2021-01-011500John Smith1None
2The Rise of AI Technologies2021-02-151800Emma JohnsonNone2
3Exploring Mars with NASA Rovers2021-03-201200David Brown3None
4Inside the Minds of Great Leaders2021-04-101600Linda LeeNone4
5The Impact of Social Media on Mental Health2021-05-011400Christopher Green5None

Authors

Author_IDFirst_NameLast_NameBiographyEmail
1JohnDoeAn award winning journalist with over 20 years of experience.john.doe@example.com
2EmmaSmithA seasoned writer who has covered a wide range of topics.emma.smith@example.com
3DavidBrownWith expertise in science journalism, David brings a unique perspective to his work.david.brown@example.com
4LindaLeeAs an investigative reporter, Linda has uncovered many important stories throughout her career.linda.lee@example.com
5ChristopherGreenHis insightful articles have made him a respected voice in mental health reporting.christopher.green@example.com

Subscriptions

Subscription_IDCustomer_NameAddressPhone_NumberSubscribed_ToStart_DateEnd_Date
1John Doe123 Main St, Anytown USA555-123-4567Newspaper2021-01-012021-12-31
2Emma Smith456 Elm St, Anothertown USA555-987-6543Magazine2021-02-152021-12-31
3David Brown789 Oak St, Yet another town USA555-135-7890Newspaper2021-03-202021-12-31
4Linda Lee123 Pine St, Somewhere USA555-555-5555Magazine2021-04-102021-12-31
5Christopher Green456 Spruce St, Everytown USA555-777-8888Newspaper2021-05-012021-12-31