Authors
AuthorID | FirstName | LastName | BirthDate |
1 | John | Smith | 2000-01-01 |
2 | Jane | Doe | 1998-06-15 |
3 | Michael | Brown | 1987-12-25 |
4 | Emily | White | 1995-09-23 |
5 | David | Black | 2003-03-04 |
Articles
ArticleID | Title | Content | PublishDate | AuthorID |
| | | | (→ Authors.AuthorID) |
1 | Article 1 | Content of article 1... | 2022-01-01 | 1 |
2 | Article 2 | Content of article 2... | 2022-01-02 | 2 |
3 | Article 3 | Content of article 3... | 2022-01-03 | 3 |
4 | Article 4 | Content of article 4... | 2022-01-04 | 4 |
5 | Article 5 | Content of article 5... | 2022-01-05 | 5 |
DistributionPlatforms
PlatformID | Name | Type |
1 | Newspaper | Print Media |
2 | Magazine | Print Media |
3 | Website | Online Media |
4 | YouTube Channel | Online Media |
Publications
PublicationID | Name | Description |
1 | Pub A | Description of pub A. |
2 | Pub B | Description of pub B. |
3 | Pub C | Description of pub C. |
4 | Pub D | Description of pub D. |
5 | Pub E | Description of pub E. |
PublishesIn
id | PublicationID | PlatformID | AudienceSize |
| (→ Publications.PublicationID) | (→ DistributionPlatforms.PlatformID) | |
1 | 1 | 1 | 300000 |
2 | 2 | 1 | 200000 |
3 | 3 | 2 | 100000 |
4 | 4 | 2 | 50000 |
5 | 5 | 3 | 100000 |
6 | 6 | 4 | 200000 |