I need help solving this case for a friend that thinks I know how to
do this. Can you help?

The Database System


The(NTJWC) is a volunteer organization located in Tampa, FL.  It draws
its membership from citizens in the city who enjoy volunteer work, and
provides financial assistance to a variety of charitable organizations
(see: http://www.gfwc.org/for additional information).  Currently, the
club tracks most of its information manually.  This task has grown
increasingly difficult as the club has grown.  Consequently, the club
has decided that the creation of a computerized database is warranted.
 The information below has been accumulated towards that goal.


The club currently has approximately 150 full members, as well as 30
provisional members (a person who has recently joined the club and is
not yet a full member).  When a member joins the club, they join as a
provisional member and are assigned one or more full members as
mentors for the first year of their membership.  Not all full members
serve as mentors, but those that do may mentor more than one
provisional member.

The club would like to be able to produce a membership list to act as
a club phone book.  This list would also facilitate the printing of
mailing labels for the newsletters sent to members.  Information
necessary for the membership list includes each member?s name (first
and last), address (street, city, state, and zip), phone number, fax
number, e-mail address, and membership status (provisional or full),
the community they live in, and whether they receive their newsletter
via regular mail or email.  They would also like to keep track of the
member?s significant other (if applicable). In addition to the member
information to be included in the membership list, the club wants to
record specific skills that the members possess that might be useful
to the organization  The names of skills currently held by club
members include typist, accountant, electrician, artist, and many
others.  A member may have many such skills.  The club has also
decided that, in anticipation of computerization, each club member
will be assigned a unique Member ID, a sequential four-digit number
(e.g., 0001, 0002, etc.) that will be used for identification
purposes.

The club?s membership is divided into six committees.  All members are
assigned to one and only one committee.  Although a member may
periodically change the committee they work on, only the current
assignment is of interest to the club.  (That is, historic records of
previous committee assignments are not important.)  The committees all
have a unique name and a specific mission.  The minimum number of
members needed for each committee is also recorded.  (This aids in the
assignment and transfer of members.)  Each committee also has a
chairperson, elected from within the membership of the committee. 
There is no set term of office for committee chairs.  (Typically, the
chair serves as long as they are willing.)  Only the current chair of
each committee is of interest.  (Records of past chairs are not kept.)

NTJWC sponsors a number of fundraising events each year.  Each event
is assigned a sequential number (Event ID) and is given a name.  Also
recorded for each event is its location, date, and starting and ending
times.  Additionally, a brief description of each event (e.g., Get out
the vote session, 2002 Book Drive, etc.) and the monetary proceeds
earned by each event are tracked.  This requires documenting the total
revenue and total cost of each event.  Also, each event has a
chairperson.  A club member may chair more than one event, or may
never hold such a position.

In addition to the money raised by the event activities themselves,
some events also receive donations.  (A specific donation is always
allocated to a single event.)  Each donation is assigned a Donation
ID, which is a unique identifier composed of the Event ID of the
involved event plus a sequential three-digit number representing the
number of the donation for the event.  (For example, the third
donation for event number 25 would be designated as 25-003.)  In
addition to the ID, also recorded for each donation is a description
of the donation (e.g., cash, art work automobile, etc.), what the
donation will be used for (door prize, live auction or silent
auction), the club member who is assigned as the contact person for
the specific donation (not all members act in this capacity, but some
do so frequently), and the monetary value of the donation (estimated
for non-cash donations).  Each donation is recorded as soon as it is
promised to NTJWC, but a notation is used to indicate whether the
donation has actually been received by NTJWC or not.  All donations
come from one and only one donor.  Each recorded donor has donated one
or more times.  Most donors are business entities, although some are
individuals.  Information tracked on each donor includes a Donor ID,
the name of the business (where applicable), the contact person?s name
(first and last) (for non-business donors, this would be the
individual donor?s name), the donor?s address (street, city, state,
and zip), phone number and email.

For each event of the year the following reports will need to be generated:

1)	A list of all donations by what the donation will be used for, and
within each type of use they want to list out those items they do not
have yet, along with the name and phone number associated with the
club member who is responsible for the item.  They would like to sum
up the worth of each donation by what it will be used for as well as
total donation monetary value.

2)	The revenue, cost and proceeds earned for each event, with a total for the year.

Each event is held to benefit one or more charities (and a charity may
benefit from one or more events).  For each charity, the club records
its name (all charities have unique names), contact person?s name
(first and last), phone, and a description of the charity?s principal
work.  NTJWC also records the dollar amount of assistance paid to each
charity from the net proceeds of each event that benefits them, and
the date that the payment is made.  An annual report of all such
charitable contributions is generated for each year, with detailed
information on each event, as well as summary information on each
charity.

 
Assignment: 

There are several areas covered in this case.  Both the data and
reporting needs are described.  There are many ways to analyze this
case and complete the assignment.  The following procedure could be
followed:
Conceptual design
o	Identify the information requirements beginning with entities, and
then add the primary key and finally add the rest of the attributes. 
Drawing an ER Diagram may be useful.
o	List the processing and reporting needs
o	Verify that all the data required to support the processing and
reporting is available. If not, augment your entities
o	Normalize your entities/relations
o	Draw an ERD of your normalized entities
Implementation
o	Select three reports, queries or forms needed to support NTJWC
o	Identify the data or tables needed to implement these reports, queries or forms
o	Build these tables and implement

Turn In
1.	Initial entities
2.	Normalized relations based on these entities
3.	ERD of the normalized relations
4.	Create the tables required and make up data to be the basis for 3
reports, queries, or forms.  NOTE:  One must be a report and one must
use more than one table.
5.	Implement the report, queries or forms