nity Theater Group

$$ General Description

The Pleasantville Community Theater Group is a nonprofit organization of about $200$ members, amateurs who enjoy producing and performing in plays. Members pay dues of $$50$ per year. The group produces two plays each year, and the members work on the productions. Not all members are active workers every year.

$$ Basic Operations

The group produces plays in the fall and in the spring. Some members of the group have roles in the plays, while others work on scenery, costumes, publicity, programs, and other tasks. The group has two general meetings per year. Each fall they meet to elect officers $-$ a president, vice president, secretary$,$ treasurer, and house manager, who serve for the entire year. At the end of the spring season, the group meets again to evaluate the previous year$$s activities and to select the two plays and their producers for the following year.$$ The producer of each play is then responsible for managing all aspects of that production, including recruiting volunteers, promotion, casting, etc. The group sometimes obtains sponsorship from local businesses for a production, and always prints a program with advertisements that help defray some of the production costs. The program also lists the cast, crew and credits for the show. The production work is generally done by the members, but skilled craftsmen are contracted as needed for specific tasks, such as electrical wiring. No professional actors are used. For a theater, the group uses the local high school auditorium, which has about $1000$ seats.

$$ Information Needs

The group wishes to have a database to keep track of members and productions. They also need to compile names and addresses of potential playgoers $($patrons$)$ so they can mail announcements to them for each production, to help sell tickets. In the past open seating has been used, but they would now like to use assigned seats, since the auditorium seats have identifying row letters and seat numbers. There are $26$ rows $($A$-$Z$)$ with $40$ seats per row. This would allow them to have subscriptions with assigned seating. The database should keep track of plays that are suitable for production by such a company. They also need to compile information about potential or past corporate sponsors.

$$ The following forms and reports are needed:

New Member Information Form $$ This form provides basic information about members such as name, address, telephone number, acting$/$directing experience

Subscriber Information Form $$ This form provides basic information about subscribers such as name, address, telephone number and the number and location of seats they wish to reserve for the coming year$$s productions.

Play Listing $-$ Plays that could be produced by the company are identified by the title, author, type $($drama$,$ comedy, musical, etc.$),$ and number of acts.

Program $-$ Cast and Credits $-$ The program for each production should list the names of members along with the role each played and the jobs each had for the production.$$

Program $$ Sponsors $-$ The program should list all the corporations and individuals who donated money, goods, or services for each production.

Patrons Report $-$ This internal report lists mailing information for patrons, as well as a list of the productions they bought tickets for in the past.

Ticket Sales R