## Author

id | name
--- | ---
1 | Shakespeare
2 | Arthur Miller
3 | Neil Simon
4 | Aphra Behn
5 | Oscar Wilde

## Theatrical_Form

id | form
--- | ---
1 | Comedy
2 | Tragedy
3 | Drama
4 | Melodrama
5 | Farce

## Play

id | title | authorId | theatricalFormId
--- | --- | --- | ---
|  | (→ Author.id) | (→ Theatrical_Form.id)
1 | Romeo and Juliet | 1 | 1
2 | Death of a Salesman | 2 | 3
3 | The Odd Couple | 3 | 1
4 | Othello | 1 | 2
5 | Aphra Behn's Comedy | 4 | 1

## Actor

id | firstName | lastName | birthYear | playId
--- | --- | --- | --- | ---
|  |  |  | (→ Play.id)
1 | Tom | Hanks | 1960 | 2
2 | John | Burton | 1987 | 3
3 | Julia | Roberts | 1990 | 4
4 | Samuel | L. Jackson | 1989 | 1
5 | Denzel | Washington | 1987 | 3

## Character

id | characterName | playId | actorId
--- | --- | --- | ---
|  | (→ Play.id) | (→ Actor.id)
1 | Cassius | 2 | 1
2 | Titus Andronicus | 1 | 4
3 | Blanche DuBois | 4 | 2
4 | Felix Unger | 3 | 3
5 | Macbeth | 1 | 5

## Role

id | roleDescription | characterId | actorId
--- | --- | --- | ---
|  | (→ Character.id) | (→ Actor.id)
1 | Friendly neighbourhood superhero | 1 | 1
2 | Rich business man | 2 | 2
3 | Kind old lady | 3 | 3
4 | Lead detective | 4 | 4
5 | Brave warrior | 5 | 5