Consider the Following Case as You Respond to the Next

Essay

Consider the following case as you respond to the next problem:
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.Single-play purchases must be paid for in cash; season passes can be paid for with cash or major credit card.The Festival Theatre deposits all its cash receipts in the bank daily.Generate field names for the patron table, sales table and the sales/play table.