## Media_Franchise

id | Name | Type | Audience | EstablishedDate
--- | --- | --- | --- | ---
1 | The Guardian | Newspaper | Liberals | 2006-08-31
2 | Fox News | Cable Network | Conservatives | 1996-04-07

## Cross_Platform_Expansion

id | FranchiseName | Platform | ExpandedSince | Audience
--- | --- | --- | --- | ---
1 | Harry Potter | App Store | 2011-09-01 | Liberals
2 | Call of Duty | Web | 2013-10-01 | Non-liberals

## Article_Category

id | Category | Description
--- | --- | ---
1 | Politics | News about government policies
2 | Technology | Advancements in computer technology

## Articles

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

## Authors

id | FirstName | LastName | Bio
--- | --- | --- | ---
1 | John | Doe | A renowned journalist
2 | Jane | Smith | An investigative reporter

## Subscriptions

id | Email | NewsletterName | StartDate
--- | --- | --- | ---
1 | john@example.com | Daily Digest | 2021-11-10
2 | jane@example.com | Weekly Update | 2021-11-11