id | Name | Type | Audience | EstablishedDate |
---|---|---|---|---|
1 | The Guardian | Newspaper | Liberals | 2006-08-31 |
2 | Fox News | Cable Network | Conservatives | 1996-04-07 |
id | FranchiseName | Platform | ExpandedSince | Audience |
---|---|---|---|---|
1 | Harry Potter | App Store | 2011-09-01 | Liberals |
2 | Call of Duty | Web | 2013-10-01 | Non-liberals |
id | Category | Description |
---|---|---|
1 | Politics | News about government policies |
2 | Technology | Advancements in computer technology |
id | Title | Content | PublishedOn | AuthorId | CategoryId |
---|---|---|---|---|---|
(→ Authors.id) | (→ Article_Category.id) | ||||
1 | Election Results | Content... | 2021-11-10 | 1 | 1 |
2 | Quantum Computing Breakthrough | Content... | 2021-11-11 | 2 | 2 |
id | FirstName | LastName | Bio |
---|---|---|---|
1 | John | Doe | A renowned journalist |
2 | Jane | Smith | An investigative reporter |
id | NewsletterName | StartDate | |
---|---|---|---|
1 | john@example.com | Daily Digest | 2021-11-10 |
2 | jane@example.com | Weekly Update | 2021-11-11 |