Audio_Media

idMedia_TypeAverage_Episode_LengthRelease_DateCreator_Name
1Podcast452021-06-01John Doe
2Podcast302021-07-01Jane Smith
3Radio Show452021-08-01Tom Brown
4Radio Show602021-09-01Emma Black

Podcasters

idName
1Alice White
2Bob Green
3Carol Blue
4David Red
5Eva Yellow

Radio_Stations

idStation_Name
1Wave FM
2Tune In AM
3Classic Rock Hits
4All Request 101
5The Sports Hub

Shows

idTitleGenreDate_First_ReleasedAudio_Media_ID
(→ Audio_Media.id)
1Mystery StoriesFiction2021-06-011
2Nature SoundsRelaxation2021-07-012
3News HeadlinesCurrent Affairs2021-08-013
4Cooking AdventuresLifestyle2021-09-014

Episodes

idEpisode_TitleRelease_DateLengthShow_ID
(→ Shows.id)
1Murder Mystery2021-06-02451
2Ocean Discovery2021-07-02602
3Daily News Update2021-08-02303
4Vegan Recipe of the Week2021-09-02454

Guests

idFirst_NameLast_NameOccupationAppearance_In_Episode_ID
(→ Episodes.id)
1SamanthaJohnsonAuthor1
2MarkWilliamsChef2
3KarenSmithJournalist3
4AlexanderBrownActor4