Theaters

theater_idnamelocation
1Broadway TheaterNew York
2West End TheatreLondon
3Apollo TheatreParis
4Drama CentreDublin
5Royal Court TheatreLiverpool

Performances

performance_idtype
1Comedy Play
2Tragedy
3Musical
4Opera
5Ballet

Theaters_Performances

theater_idperformance_id
(→ Theaters.theater_id)(→ Performances.performance_id)
11
21
31
41
51

Actors

actor_idfirst_namelast_name
1John DoeDoe
2Jane SmithSmith
3Michael JohnsonJohnson
4Emily DavisDavis
5William BrownBrown

Roles

role_iddescription
1Lead Role
2Supporting Role
3Villain
4Protagonist
5Antagonist