Podcast

idDebut_DayDebut_YearTitleHostsDuration
1Monday2021The Morning ShowJane Doe and John Smith60
2Tuesday2020Technology TodayAlice Johnson30
3Wednesday2021Cooking with Chef MikeMike Brown45
4Thursday2019Health MattersDr. Lisa Wilson35
5Friday2020News RoundupTom Harris60

Episode

idPodcast_idEpisode_NumberRelease_DateLength
(→ Podcast.id)
1112021-07-0160
2122021-07-0860
3212021-07-1530
4312021-07-0145
5412020-07-0135

Category

idName
1Entertainment
2Technology
3Food & Cooking
4Health & Fitness
5News

Podcast_Category

Podcast_idCategory_id
(→ Podcast.id)(→ Category.id)
11
22
33
44
55

Subscriber

idEmailPasswordJoined_Date
1john@example.compassword1232021-06-01
2alice@example.comsecret4562021-06-15
3bob@example.comabc7892021-07-01
4charlie@example.comxyz1232021-07-15
5diana@example.commno4562021-08-01

Subscription

Subscriber_idPodcast_idStart_DateEnd_Date
(→ Subscriber.id)(→ Podcast.id)
112021-07-012021-08-01
122021-07-012021-08-01
232021-07-152021-08-15
342021-07-012021-08-01
452021-07-152021-08-15