## Theater_Company

id | name | address
--- | --- | ---
1 | The Royal Theatre | 123 Main St
2 | Drama House | 456 Broadway

## Producer

id | name | email
--- | --- | ---
1 | John Doe | johndoe@gmail.com
2 | Jane Smith | janesmith@yahoo.com

## Stage_Play

id | title | description | theater_company_id | producer_id
--- | --- | --- | --- | ---
|  |  | (→ Theater_Company.id) | (→ Producer.id)
1 | Hamlet | A classic tragedy by William Shakespeare. | 1 | 1
2 | Othello | Another great work from Shakespeare. | 1 | 1

## Actor

id | first_name | last_name
--- | --- | ---
1 | Tom | Cruise
2 | Matthew | McConaughey

## Play_Actor

play_id | actor_id | character_played
--- | --- | ---
(→ Stage_Play.id) | (→ Actor.id) |
1 | 1 | Hamlet
2 | 1 | Othello
1 | 2 | Laertes
2 | 2 | Iago

## Review

id | rating | reviewer_email | stage_play_id
--- | --- | --- | ---
|  |  | (→ Stage_Play.id)
1 | 8 | reviews@hotmail.com | 1
2 | 9 | reviews@outlook.com | 2