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 |