## Platform

id | name | url
--- | --- | ---
1 | CNN | https://www.cnn.com
2 | BBC | https://www.bbc.co.uk
3 | The Guardian | https://www.theguardian.com
4 | Al Jazeera | https://www.aljazeera.com
5 | New York Times | https://www.nytimes.com

## Article

id | title | content | publishedDate | newsAgencyId
--- | --- | --- | --- | ---
|  |  |  | (→ News_Agency.id)
1 | Test Article 1 | This is a test article. | 2024-02-19 14:31:13 | 1
2 | Test Article 2 | Another test article. | 2024-02-19 14:31:13 | 2
3 | Test Article 3 | Yet another test article. | 2024-02-19 14:31:13 | 3
4 | Test Article 4 | And here is one more test article. | 2024-02-19 14:31:13 | 4
5 | Test Article 5 | Last but not least, a test article! | 2024-02-19 14:31:13 | 5

## Author

id | firstName | lastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Johnson
4 | Emily | Williams
5 | David | Brown

## AuthorArticle

authorId | articleId
--- | ---
(→ Author.id) | (→ Article.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## News_Agency

id | name | websiteId
--- | --- | ---
|  | (→ Platform.id)
1 | CNN | 1
2 | BBC | 2
3 | The Guardian | 3
4 | Al Jazeera | 4
5 | New York Times | 5