Media_Franchise

idNameTypeAudienceEstablishedDate
1The GuardianNewspaperLiberals2006-08-31
2Fox NewsCable NetworkConservatives1996-04-07

Cross_Platform_Expansion

idFranchiseNamePlatformExpandedSinceAudience
1Harry PotterApp Store2011-09-01Liberals
2Call of DutyWeb2013-10-01Non-liberals

Article_Category

idCategoryDescription
1PoliticsNews about government policies
2TechnologyAdvancements in computer technology

Articles

idTitleContentPublishedOnAuthorIdCategoryId
(→ Authors.id)(→ Article_Category.id)
1Election ResultsContent...2021-11-1011
2Quantum Computing BreakthroughContent...2021-11-1122

Authors

idFirstNameLastNameBio
1JohnDoeA renowned journalist
2JaneSmithAn investigative reporter

Subscriptions

idEmailNewsletterNameStartDate
1john@example.comDaily Digest2021-11-10
2jane@example.comWeekly Update2021-11-11