Draw an Entity-Relationship Diagram of the situation described below.

 Draw an Entity-Relationship Diagram of the situation described below. For each entity, indicate its
name, the primary key and its attributes. For each relationship, show the cardinality of the relationship.
Use either the Crow’s foot notation or the UML notation for the cardinalities.
Draw the diagram on a computer.
You have been given a consulting job to help a local chapter of a woman’s volunteer club create a
database to maintain various lists and generate reports. The club undertakes a number of charitable
events and outreach programs. It has approximately 150 current members as well as 30 provisional
members (a new member before she becomes a full member).
The database will track for each member her first name, last name, street address, phone, email,
whether she receives the newsletter via mail or email, and whether she is a provisional member.
There are seven committees, each of which undertakes between three and seven events per year. All
club members must join one, and only one, committee. Each committee has a name and a specific
mission and works on several events during the year. These events have names, take place in specific
locations, and have a begin date and time as well as an end date and time. There is also a short
description for each event, which is run by one, and only one, committee.
A club member can work on any event regardless of committee affiliation. Events receive donations that
have a monetary value, a description, and the name of the club member who is the contact person for
each donation. It is necessary to show if the donation has been received.
Donations come from one and only one donor, but a donor can make many donations. Donor
information includes the name of the donating organization, address, contact person’s name, and a
phone number.
Each event benefits one or more charities and a charity may also benefit from one or more events. For
each charity, we want to track its name, contact information, and a description of its work. For each
event, the benefiting charities receive a percentage of the proceeds (for instance, from the Fall Ball
proceeds, MADD may get 50%, Habitat for Humanity 25%, and Sierra Club 25%).
All committees have one club member assigned as a chairperson. Also, all events have one club member
assigned as a chairperson.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.