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 |