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