## Audio_Media

id | Media_Type | Average_Episode_Length | Release_Date | Creator_Name
--- | --- | --- | --- | ---
1 | Podcast | 45 | 2021-06-01 | John Doe
2 | Podcast | 30 | 2021-07-01 | Jane Smith
3 | Radio Show | 45 | 2021-08-01 | Tom Brown
4 | Radio Show | 60 | 2021-09-01 | Emma Black

## Podcasters

id | Name
--- | ---
1 | Alice White
2 | Bob Green
3 | Carol Blue
4 | David Red
5 | Eva Yellow

## Radio_Stations

id | Station_Name
--- | ---
1 | Wave FM
2 | Tune In AM
3 | Classic Rock Hits
4 | All Request 101
5 | The Sports Hub

## Shows

id | Title | Genre | Date_First_Released | Audio_Media_ID
--- | --- | --- | --- | ---
|  |  |  | (→ Audio_Media.id)
1 | Mystery Stories | Fiction | 2021-06-01 | 1
2 | Nature Sounds | Relaxation | 2021-07-01 | 2
3 | News Headlines | Current Affairs | 2021-08-01 | 3
4 | Cooking Adventures | Lifestyle | 2021-09-01 | 4

## Episodes

id | Episode_Title | Release_Date | Length | Show_ID
--- | --- | --- | --- | ---
|  |  |  | (→ Shows.id)
1 | Murder Mystery | 2021-06-02 | 45 | 1
2 | Ocean Discovery | 2021-07-02 | 60 | 2
3 | Daily News Update | 2021-08-02 | 30 | 3
4 | Vegan Recipe of the Week | 2021-09-02 | 45 | 4

## Guests

id | First_Name | Last_Name | Occupation | Appearance_In_Episode_ID
--- | --- | --- | --- | ---
|  |  |  | (→ Episodes.id)
1 | Samantha | Johnson | Author | 1
2 | Mark | Williams | Chef | 2
3 | Karen | Smith | Journalist | 3
4 | Alexander | Brown | Actor | 4