## Play

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

## Character

ID | Name | PlayID
--- | --- | ---
|  | (→ Play.ID)
1 | Juliet | 1
2 | Shakespeare | 1
3 | Puck | 2
4 | Katherine | 4
5 | Banquo | 5

## Actor

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

## Role

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

## Theater

ID | Name
--- | ---
1 | The Royal Shakespeare Company
2 | Broadway Theatre
3 | Drury Lane Theatre
4 | Harold Pinter Theatre
5 | Gielgud Theatre

## Production

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