Authors

AuthorIDNameBirthDateNationality
1John Doe1970-06-15American
2Jane Smith1985-03-20British

Articles

ArticleIDTitlePublishDateWordCountContentAuthorID
(→ Authors.AuthorID)
1My First Article2021-01-01500This is my first article.1
2Another Interesting Piece2021-02-011000Here is another interesting piece.1

Pulitzers

PrizeIDAwardedArticleIDCategoryYear
(→ Articles.ArticleID)
11Feature Writing2010
22Breaking News Reporting2011

Polks

AwardIDAwardedArticleIDCategoryYear
(→ Articles.ArticleID)
11International Reporting2010
22National Security Reporting2011

Magazines

MagazineIDNamePublicationFrequencyHeadquarterLocation
1TimeWeeklyNew York City
2The EconomistWeeklyLondon

Subscriptions

SubscriptionIDCustomerIDMagazineIDStartDateEndDate
(→ Customers.CustomerID)(→ Magazines.MagazineID)
1112021-01-012021-12-31
2222021-01-012021-12-31