## Students

id | name | age | major
--- | --- | --- | ---
1 | John Doe | 20 | Journalism
2 | Jane Smith | 23 | Mass Communication
3 | Michael Johnson | 22 | Media Studies
4 | Emma Brown | 21 | Broadcast Journalism
5 | Anne Smith | 24 | Print Journalism

## NewsArticles

id | title | content | structure | published_date | student_name
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Students.name)
1 | First Article Title | Content of first article... | Inverted Pyramid | 2022-01-01 | Anne Smith
2 | Second Article Title | Content of second article... | Inverted Pyramid | 2022-01-02 | Michael Johnson
3 | Third Article Title | Content of third article... | Chronological Structure | 2022-01-03 | Anne Smith
4 | Fourth Article Title | Content of fourth article... | Chronological Structure | 2022-01-04 | Emma Brown
5 | Fifth Article Title | Content of fifth article... | Inverted Pyramid | 2022-01-05 | John Doe

## ArticleCategories

category_id | category_name
--- | ---
1 | Politics
2 | Economy
3 | Technology
4 | Entertainment
5 | Sports

## ArticlesByCategory

article_id | category_id
--- | ---
(→ NewsArticles.id) | (→ ArticleCategories.category_id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Sources

source_id | source_name | url
--- | --- | ---
1 | The Guardian | https://www.theguardian.com/
2 | BBC News | https://www.bbc.co.uk/news
3 | Al Jazeera | https://www.aljazeera.com/
4 | Reuters | https://www.reuters.com/
5 | The New York Times | https://www.nytimes.com/

## ArticlesWithSources

article_id | source_id
--- | ---
(→ NewsArticles.id) | (→ Sources.source_id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5