## Host

id | name
--- | ---
1 | Alex Johnson
2 | John Doe

## Podcast

id | title | host_id | release_date
--- | --- | --- | ---
|  | (→ Host.id) |
1 | Tech Talk | 1 | 2023-01-01
2 | Cooking Show | 2 | 2023-01-07

## Radio_Show

id | title | host_id | airing_time
--- | --- | --- | ---
|  | (→ Host.id) |
1 | Morning Rush | 1 | 06:00 AM
2 | Evening Chill | 2 | 08:00 PM

## Episode

id | podcast_title | episode_number | released_on | content
--- | --- | --- | --- | ---
1 | Tech Talk | 1 | 2023-01-01 | Discussion about AI and its impact on society.
2 | Tech Talk | 2 | 2023-01-08 | Interview with a top AI researcher.
3 | Cooking Show | 1 | 2023-01-07 | Recipe for the perfect pasta dish.
4 | Cooking Show | 2 | 2023-01-14 | Baking tips for beginners.

## Guest

id | fullname | occupation
--- | --- | ---
1 | Jane Smith | AI Researcher
2 | Tom Brown | Chef