The Festival Theatre Produces Twelve Plays Per Year

question 42

Essay

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.

---

Definitions:

Combined ROI

A metric that aggregates the return on investment (ROI) from multiple projects or investments to assess overall performance.

Investment Opportunity

A potential investment that could yield financial returns, often evaluated for its risk-reward profile.

Company

An organized entity formed to conduct business activities, selling goods or services in exchange for profit.

Last Year's Margin

Represents the difference between the sales revenue and the cost of goods sold from the previous year, often expressed as a percentage of sales.