The Festival Theatre produces twelve plays per year.Patrons can buy tickets for a single play; alternatively, they can purchase a season pass for either three plays or six plays.Three-play passes offer a 10% discount from the prices of single tickets; six-play passes, a 25% discount.Since most patrons live within 30 miles of the theatre, all ticket sales are done at the box office only.The theatre has an "open seating" plan, so patrons do not reserve a specific seat at any performance.Create specifications (table names and field names) for three tables the theatre would need to track ticket sales; if a junction table is indicated, you must include its specifications as one of the three.

Question

Quizplus · Accepted Answer

The Answer of The Festival Theatre produces twelve plays per year.Patrons can buy tickets for a single play; alternatively, they can purchase a season pass for either three plays or six plays.Three-play passes offer a 10% discount from the prices of single tickets; six-play passes, a 25% discount.Since most patrons live within 30 miles of the theatre, all ticket sales are done at the box office only.The theatre has an "open seating" plan, so patrons do not reserve a specific seat at any performance.Create specifications (table names and field names) for three tables the theatre would need to track ticket sales; if a junction table is indicated, you must include its specifications as one of the three.

The Festival Theatre Produces Twelve Plays Per Year