## Theatres

id | name | location
--- | --- | ---
1 | Broadway Theatre | New York City
2 | Shakespeare Theatre | Washington DC
3 | Globe Theatre | London
4 | Imperial Theatre | Toronto
5 | National Theatre | Paris

## Plays

id | title | genre
--- | --- | ---
1 | Hamlet | Tragedy
2 | Macbeth | Tragedy
3 | A Midsummer Night's Dream | Comedy
4 | Othello | Tragedy
5 | King Lear | Tragedy

## Actors

id | firstName | lastName
--- | --- | ---
1 | Tom | Hanks
2 | Meryl | Streep
3 | Leonardo | DiCaprio
4 | Jennifer | Lawrence
5 | Robert | Downey Jr.

## Directors

id | firstName | lastName
--- | --- | ---
1 | Martin | Scorsese
2 | Steven | Spielberg
3 | Christopher | Nolan
4 | Quentin | Tarantino
5 | Baz | Luhrmann

## TheatrePerformances

theatreId | playId | performanceDate | actorId | directorId
--- | --- | --- | --- | ---
(→ Theatres.id) | (→ Plays.id) |  | (→ Actors.id) | (→ Directors.id)
1 | 1 | 2023-07-01 | 1 | 1
1 | 2 | 2023-07-15 | 2 | 2
2 | 1 | 2023-08-01 | 3 | 3
2 | 2 | 2023-08-15 | 4 | 4
3 | 1 | 2023-09-01 | 5 | 5
4 | 1 | 2023-09-01 | 2 | 3
5 | 1 | 2023-09-01 | 3 | 2