| id | name |
|---|---|
| 1 | Shakespeare |
| 2 | Arthur Miller |
| 3 | Neil Simon |
| 4 | Aphra Behn |
| 5 | Oscar Wilde |
| id | form |
|---|---|
| 1 | Comedy |
| 2 | Tragedy |
| 3 | Drama |
| 4 | Melodrama |
| 5 | Farce |
| 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 |
| 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 |
| 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 |
| 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 |