TelevisionShows
ID | Name | Genre | Country | Television_Format | Audience_Score |
1 | MasterChef | Cooking Show | USA | TV Series | 7.5 |
2 | Top Chef | Cooking Show | USA | TV Series | 8.0 |
3 | Survivor | Reality TV Show | USA | TV Series | 7.5 |
4 | Big Brother | Reality TV Show | USA | TV Series | 6.9 |
Actors
ActorID | FirstName | LastName | DateOfBirth | Nationality |
1 | John | Doe | 1972-03-15 | USA |
2 | Jane | Smith | 1985-06-23 | UK |
ShowsActors
ShowID | ActorID | Role |
(→ TelevisionShows.ID) | (→ Actors.ActorID) | |
1 | 1 | Host |
1 | 2 | Co-host |
Directors
DirectorID | FirstName | LastName | BirthDate | Nationality |
1 | William | Ramirez | 1965-08-10 | USA |
2 | Emma | Thompson | 1965-12-15 | UK |
ShowDirectors
ShowID | DirectorID |
(→ TelevisionShows.ID) | (→ Directors.DirectorID) |
1 | 1 |
2 | 2 |