Authors
AuthorID | FirstName | LastName | BirthDate |
1 | John | Doe | 1980-06-01 |
2 | Jane | Smith | 1975-03-15 |
Articles
ArticleID | Title | PublicationDate | WordCount | AuthorID |
| | | | (→ Authors.AuthorID) |
1 | Sample Article 1 | 2021-01-01 00:00:00 | 500 | 1 |
2 | Sample Article 2 | 2021-02-01 00:00:00 | 750 | 1 |
NewsOutlets
OutletID | Name | Location | FoundedYear |
1 | Newspaper A | City A | 1900 |
2 | Newspaper B | City B | 1950 |
Publishes
PublishID | ArticleID | OutletID |
| (→ Articles.ArticleID) | (→ NewsOutlets.OutletID) |
1 | 1 | 1 |
2 | 2 | 2 |
Audience
DemoID | Age_Group | Income_Level | Article |
| | | (→ Articles.ArticleID) |
1 | 25-34 | High | 1 |
2 | 35-44 | Medium | 2 |
Advertisements
AdvID | Description | Budget | StartDate | EndDate | OutletID |
| | | | | (→ NewsOutlets.OutletID) |
1 | Advertisement 1 | 1000 | 2021-01-01 00:00:00 | 2021-01-31 23:59:59 | 1 |
2 | Advertisement 2 | 1500 | 2021-02-01 00:00:00 | 2021-02-28 23:59:59 | 2 |