## Authors

AuthorID | Name | BirthDate | Nationality
--- | --- | --- | ---
1 | John Doe | 1970-06-15 | American
2 | Jane Smith | 1985-03-20 | British

## Articles

ArticleID | Title | PublishDate | WordCount | Content | AuthorID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Authors.AuthorID)
1 | My First Article | 2021-01-01 | 500 | This is my first article. | 1
2 | Another Interesting Piece | 2021-02-01 | 1000 | Here is another interesting piece. | 1

## Pulitzers

PrizeID | AwardedArticleID | Category | Year
--- | --- | --- | ---
| (→ Articles.ArticleID) |  |
1 | 1 | Feature Writing | 2010
2 | 2 | Breaking News Reporting | 2011

## Polks

AwardID | AwardedArticleID | Category | Year
--- | --- | --- | ---
| (→ Articles.ArticleID) |  |
1 | 1 | International Reporting | 2010
2 | 2 | National Security Reporting | 2011

## Magazines

MagazineID | Name | PublicationFrequency | HeadquarterLocation
--- | --- | --- | ---
1 | Time | Weekly | New York City
2 | The Economist | Weekly | London

## Subscriptions

SubscriptionID | CustomerID | MagazineID | StartDate | EndDate
--- | --- | --- | --- | ---
| (→ Customers.CustomerID) | (→ Magazines.MagazineID) |  |
1 | 1 | 1 | 2021-01-01 | 2021-12-31
2 | 2 | 2 | 2021-01-01 | 2021-12-31