Draw the E-R diagram in Visio showing only entities and relationships between th

Question

Draw the E-R diagram in Visio showing only entities and relationships between them. Make sure you identify the weak entity sets, and also cardinality and participation constraints for each relationship using appropriate symbols in your E-R diagram.

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

Explanation / Answer

Entity Relationship Diagrams tell a story. An employee is assigned one department. A location can house one or more departments. Jeff doesn

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.