ID | Title | Theatrical_Form | Author | Year_Published |
---|---|---|---|---|
1 | Romeo And Juliet | Tragedy | William Shakespeare | 1597 |
2 | A Midsummer Night's Dream | Comedy | William Shakespeare | 1596 |
3 | Hamlet | Tragedy | William Shakespeare | 1603 |
4 | Taming Of Shrew | Comedy | Christopher Marlowe | 1594 |
5 | Macbeth | Tragedy | William Shakespeare | 1606 |
ID | Name | PlayID |
---|---|---|
(→ Play.ID) | ||
1 | Juliet | 1 |
2 | Shakespeare | 1 |
3 | Puck | 2 |
4 | Katherine | 4 |
5 | Banquo | 5 |
ID | Name | Birthdate |
---|---|---|
1 | Laurence Olivier | 1907-05-22 |
2 | Sir Ian McKellen | 1948-05-25 |
3 | Denzel Washington | 1954-12-27 |
4 | Samuel L Jackson | 1948-12-21 |
5 | Tom Hiddleston | 1981-02-09 |
ID | CharacterID | ActorID | PerformanceDate |
---|---|---|---|
(→ Character.ID) | (→ Actor.ID) | ||
1 | 1 | 1 | 1954-01-01 |
2 | 1 | 2 | 1981-02-01 |
3 | 2 | 3 | 2000-06-01 |
4 | 3 | 4 | 1990-09-01 |
5 | 4 | 5 | 2003-12-01 |
ID | Name |
---|---|
1 | The Royal Shakespeare Company |
2 | Broadway Theatre |
3 | Drury Lane Theatre |
4 | Harold Pinter Theatre |
5 | Gielgud Theatre |
ID | PlayID | TheaterID | Start_Date | End_Date |
---|---|---|---|---|
(→ Play.ID) | (→ Theater.ID) | |||
1 | 1 | 1 | 1954-01-01 | 1955-06-01 |
2 | 2 | 2 | 1981-02-01 | 1982-06-01 |
3 | 3 | 3 | 1990-09-01 | 1991-09-01 |
4 | 4 | 4 | 2003-12-01 | 2004-01-01 |
5 | 5 | 5 | 2000-06-01 | 2000-08-01 |