Consider the Following Case as You Respond to the Next

question 28

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.

---

Definitions:

Subcutaneous Injection

A method of administering medication under the skin into the fatty tissue layer between the skin and the muscle.

Stethoscope

A medical instrument used for listening to sounds produced within the body, particularly the heart and lungs, in order to diagnose conditions.

Body Sounds

The noises produced within the body that can be heard during a medical examination, such as heartbeats or lung sounds.

Examination Light

A focused light source used in medical settings to illuminate the examination area for clearer observation.