## CookingShows

id | showName | hostName | network | duration
--- | --- | --- | --- | ---
1 | MasterChef | Gordon Ramsay | FOX | 60.0
2 | Great British Bake Off | Mary Berry | BBC One | 60.0
3 | Chopped | Ted Allen | Food Network | 30.0
4 | Top Chef | Padma Lakshmi | Bravo | 42.0
5 | Hell's Kitchen | Gordon Ramsay | FOX | 45.0

## RealityTVShows

id | showName | hostName | network | seasonCount
--- | --- | --- | --- | ---
1 | Survivor | Jeff Probst | CBS | 41
2 | American Idol | Ryan Seacrest | ABC | 19
3 | The Voice | Carson Daly | NBC | 21
4 | Big Brother | Julie Chen | CBS | 23
5 | Dancing With The Stars | Tom Bergeron | ABC | 29

## AudienceScores

id | showId | score
--- | --- | ---
| (→ CookingShows.id) |
1 | 1 | 7.5
2 | 2 | 8.2
3 | 3 | 7.5
4 | 4 | 8.0

## ActorProfiles

id | firstName | lastName | birthDate | nationality
--- | --- | --- | --- | ---
1 | Gordon | Ramsay | 1966-10-08 | Scotland
2 | Mary | Berry | 1950-04-05 | England
3 | Ted | Allen | 1970-06-26 | United States
4 | Padma | Lakshmi | 1970-09-01 | India
5 | Jeff | Probst | 1961-04-13 | United States

## ShowCast

id | cookingShowId | realityTVShowId | actorProfileId | role
--- | --- | --- | --- | ---
| (→ CookingShows.id) | (→ RealityTVShows.id) | (→ ActorProfiles.id) |
1 | 1 | None | 1 | Host
2 | None | 3 | 2 | Host
3 | 2 | None | 3 | Co-host
4 | None | 4 | 4 | Host
5 | 1 | None | 5 | Guest Judge

## EpisodeDetails

id | cookingShowId | realityTVShowId | episodeNumber | releaseDate | description | director | writer
--- | --- | --- | --- | --- | --- | --- | ---
| (→ CookingShows.id) | (→ RealityTVShows.id) |  |  |  |  |
1 | 1 | None | 1 | 2021-09-20 | First episode of MasterChef Season 9. | John Smith | Jane Doe
2 | None | 3 | 1 | 2021-09-21 | Premiere episode of Survivor Season 41. | Jim Johnson | Mike Miller
3 | 2 | None | 1 | 2021-09-23 | Inaugural episode of Great British Bake Off Season 11. | Emily Brown | David Wilson
4 | None | 4 | 1 | 2021-09-22 | Season opener of Big Brother Season 23. | Karen Lee | Mark Thompson
5 | 1 | None | 1 | 2021-09-22 | Introducing contestants and challenges on Hell's Kitchen Season 20. | Paul Williams | Steve Stark