## 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