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 |