## Reporters

id | name | birthDate | email
--- | --- | --- | ---
1 | John Doe | 1987-06-13 | john@example.com
2 | Jane Smith | 1990-03-18 | jane@example.com

## Articles

id | title | content | publishDate | reporterId | categoryId
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Reporters.id) | (→ Categories.id)
1 | Article Title 1 | Content of article 1 | 2021-07-01 | 1 | 1
2 | Article Title 2 | Content of article 2 | 2021-07-02 | 2 | 2

## Categories

id | name
--- | ---
1 | Politics
2 | Economy
3 | Technology

## Awards

id | awardName | year
--- | --- | ---
1 | Pulitzer Prize | 2010
2 | Pulitzer Prize | 2011
3 | George Polk Award | 2010
4 | George Polk Award | 2012

## Reporter_Awards

reporterId | awardId
--- | ---
(→ Reporters.id) | (→ Awards.id)
1 | 1
2 | 2