| 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 |
| 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 |
| id | showId | score |
|---|---|---|
| (→ CookingShows.id) | ||
| 1 | 1 | 7.5 |
| 2 | 2 | 8.2 |
| 3 | 3 | 7.5 |
| 4 | 4 | 8.0 |
| 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 |
| 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 |
| 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 |