Newspapers
id | name | publisher |
1 | The Guardian | Scott Trust |
2 | Financial Times | Pearson PLC |
Magazines
id | title | editor |
1 | National Geographic | Grady McPeek |
2 | Time Magazine | Edward Felsenthal |
Publications
id | frequency |
1 | Daily |
2 | Monthly |
3 | Quarterly |
Authors
id | name | contact |
1 | George Orwell | georgeorwell@email.com |
2 | Ayn Rand | aynrand@email.com |
Articles
id | content | pubDate | newspaperID | magazineID | authorID | publicationID |
| | | (→ Newspapers.id) | (→ Magazines.id) | (→ Authors.id) | (→ Publications.id) |
1 | Article1 Content | 2024-03-13 21:31:38 | 1 | None | 1 | 1 |
2 | Article2 Content | 2024-03-13 21:31:38 | 2 | None | 2 | 3 |
3 | Article3 Content | 2024-03-13 21:31:38 | 1 | 1 | 1 | 2 |
4 | Article4 Content | 2024-03-13 21:31:38 | 2 | 2 | 2 | 1 |
5 | Article5 Content | 2024-03-13 21:31:38 | 1 | 1 | 1 | 3 |