| AuthorID | Name | BirthDate | Nationality |
|---|---|---|---|
| 1 | John Doe | 1970-06-15 | American |
| 2 | Jane Smith | 1985-03-20 | British |
| 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 |
| PrizeID | AwardedArticleID | Category | Year |
|---|---|---|---|
| (→ Articles.ArticleID) | |||
| 1 | 1 | Feature Writing | 2010 |
| 2 | 2 | Breaking News Reporting | 2011 |
| AwardID | AwardedArticleID | Category | Year |
|---|---|---|---|
| (→ Articles.ArticleID) | |||
| 1 | 1 | International Reporting | 2010 |
| 2 | 2 | National Security Reporting | 2011 |
| MagazineID | Name | PublicationFrequency | HeadquarterLocation |
|---|---|---|---|
| 1 | Time | Weekly | New York City |
| 2 | The Economist | Weekly | London |
| 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 |