## Magazine

id | Name | Social_Media | Email_Newsletters
--- | --- | --- | ---
1 | The New Yorker | https://www.facebook.com/newyorkermag | newsletter@thenewyorker.com
2 | Wired | https://www.twitter.com/wired | newsletter@wired.com
3 | National Geographic | https://www.instagram.com/natgeo | newsletter@nationalgeographic.com
4 | Time | https://www.linkedin.com/company/time | newsletter@time.com
5 | New Scientist | https://www.youtube.com/c/newscientistvideos | newsletter@newscientist.com

## Author

id | FirstName | LastName | Bio
--- | --- | --- | ---
1 | John | Doe | A writer based in London.
2 | Jane | Smith | An author who loves travelling and writing about her experiences.
3 | Michael | Brown | A renowned journalist known for his investigative work.
4 | Emily | White | An expert on environmental issues.
5 | William | Black | A political analyst and commentator.

## Article

id | Title | Content | PublishDate | MagazineID
--- | --- | --- | --- | ---
|  |  |  | (→ Magazine.id)
1 | The Future of AI | AI is changing our world... | 2024-03-13 20:53:33 | 1
2 | Climate Change Effects | Effects of climate change... | 2024-03-13 20:53:33 | 2
3 | Exploring Mars | Details about recent discoveries... | 2024-03-13 20:53:33 | 3
4 | Health Benefits of Exercise | Benefits of daily exercise... | 2024-03-13 20:53:33 | 4
5 | Tech Trends of 2022 | Predictions for the year ahead... | 2024-03-13 20:53:33 | 5

## Readership

id | FullName | Age | City | Preferred_Magazines
--- | --- | --- | --- | ---
1 | John Doe | 28 | Los Angeles | The New Yorker, Wired
2 | Jane Smith | 35 | Chicago | National Geographic, Time
3 | Michael Brown | 42 | San Francisco | New Scientist, National Geographic
4 | Emily White | 31 | Denver | The New Yorker, The Economist
5 | William Black | 47 | Seattle | Time, Forbes

## Subscription

id | ReaderID | MagazineID | StartDate | EndDate
--- | --- | --- | --- | ---
| (→ Readership.id) | (→ Magazine.id) |  |
1 | 1 | 1 | 2022-01-01 | None
2 | 2 | 2 | 2022-02-01 | 2022-12-31
3 | 3 | 3 | 2022-03-01 | 2023-02-28
4 | 4 | 4 | 2022-04-01 | 2023-03-31
5 | 5 | 5 | 2022-05-01 | None

## Comment

id | Content | ArticleID | AuthorID
--- | --- | --- | ---
|  | (→ Article.id) | (→ Author.id)
1 | Great article! | 1 | 1
2 | Very informative piece. | 2 | 2
3 | Interesting insights. | 3 | 3
4 | Well-written and engaging. | 4 | 4
5 | I enjoyed this perspective. | 5 | 5