Play

IDTitleTheatrical_FormAuthorYear_Published
1Romeo And JulietTragedyWilliam Shakespeare1597
2A Midsummer Night's DreamComedyWilliam Shakespeare1596
3HamletTragedyWilliam Shakespeare1603
4Taming Of ShrewComedyChristopher Marlowe1594
5MacbethTragedyWilliam Shakespeare1606

Character

IDNamePlayID
(→ Play.ID)
1Juliet1
2Shakespeare1
3Puck2
4Katherine4
5Banquo5

Actor

IDNameBirthdate
1Laurence Olivier1907-05-22
2Sir Ian McKellen1948-05-25
3Denzel Washington1954-12-27
4Samuel L Jackson1948-12-21
5Tom Hiddleston1981-02-09

Role

IDCharacterIDActorIDPerformanceDate
(→ Character.ID)(→ Actor.ID)
1111954-01-01
2121981-02-01
3232000-06-01
4341990-09-01
5452003-12-01

Theater

IDName
1The Royal Shakespeare Company
2Broadway Theatre
3Drury Lane Theatre
4Harold Pinter Theatre
5Gielgud Theatre

Production

IDPlayIDTheaterIDStart_DateEnd_Date
(→ Play.ID)(→ Theater.ID)
1111954-01-011955-06-01
2221981-02-011982-06-01
3331990-09-011991-09-01
4442003-12-012004-01-01
5552000-06-012000-08-01