Author

idname
1Shakespeare
2Arthur Miller
3Neil Simon
4Aphra Behn
5Oscar Wilde

Theatrical_Form

idform
1Comedy
2Tragedy
3Drama
4Melodrama
5Farce

Play

idtitleauthorIdtheatricalFormId
(→ Author.id)(→ Theatrical_Form.id)
1Romeo and Juliet11
2Death of a Salesman23
3The Odd Couple31
4Othello12
5Aphra Behn's Comedy41

Actor

idfirstNamelastNamebirthYearplayId
(→ Play.id)
1TomHanks19602
2JohnBurton19873
3JuliaRoberts19904
4SamuelL. Jackson19891
5DenzelWashington19873

Character

idcharacterNameplayIdactorId
(→ Play.id)(→ Actor.id)
1Cassius21
2Titus Andronicus14
3Blanche DuBois42
4Felix Unger33
5Macbeth15

Role

idroleDescriptioncharacterIdactorId
(→ Character.id)(→ Actor.id)
1Friendly neighbourhood superhero11
2Rich business man22
3Kind old lady33
4Lead detective44
5Brave warrior55