Theater_Company

idnameaddress
1The Royal Theatre123 Main St
2Drama House456 Broadway

Producer

idnameemail
1John Doejohndoe@gmail.com
2Jane Smithjanesmith@yahoo.com

Stage_Play

idtitledescriptiontheater_company_idproducer_id
(→ Theater_Company.id)(→ Producer.id)
1HamletA classic tragedy by William Shakespeare.11
2OthelloAnother great work from Shakespeare.11

Actor

idfirst_namelast_name
1TomCruise
2MatthewMcConaughey

Play_Actor

play_idactor_idcharacter_played
(→ Stage_Play.id)(→ Actor.id)
11Hamlet
21Othello
12Laertes
22Iago

Review

idratingreviewer_emailstage_play_id
(→ Stage_Play.id)
18reviews@hotmail.com1
29reviews@outlook.com2