| AuthorID | FirstName | LastName |
|---|---|---|
| 1 | John | Doe |
| 2 | Jane | Smith |
| 3 | Bob | Johnson |
| 4 | Mary | Williams |
| 5 | Tom | Brown |
| PublisherID | Name | YearOfEstablishment |
|---|---|---|
| 1 | New York Times | 1851 |
| 2 | Washington Post | 1877 |
| 3 | Los Angeles Times | 1881 |
| 4 | Chicago Tribune | 1847 |
| 5 | USA Today | 1982 |
| ArticleID | Title | Content | DatePublished | AuthorID | PublisherID |
|---|---|---|---|---|---|
| (→ Authors.AuthorID) | (→ Publications.PublisherID) | ||||
| 1 | The Rise of AI | AI has revolutionized many industries... | 2023-06-15 | 1 | 1 |
| 2 | Climate Change Crisis | Human activities have caused climate change... | 2023-06-16 | 2 | 2 |
| 3 | Technology Trends | The future of technology looks promising... | 2023-06-17 | 3 | 3 |
| 4 | Economic Outlook | Global economy faces challenges ahead... | 2023-06-18 | 4 | 4 |
| 5 | Political Updates | Latest political news from around the world... | 2023-06-19 | 5 | 5 |
| AwardID | AwardType |
|---|---|
| 1 | Pulitzer Prize |
| 2 | George Polk Award |
| id | WinningArticleID | Year | AwardID |
|---|---|---|---|
| (→ Articles.ArticleID) | (→ Awards.AwardID) | ||
| 1 | 1 | 2010 | 1 |
| 2 | 2 | 2011 | 1 |
| 3 | 3 | 2010 | 2 |
| 4 | 4 | 2012 | 2 |
| 5 | 5 | 2013 | 2 |