Political Contribution Database
I would like you to create another database. I want you to create a database of contributions to the
political campaign.
The information you need to keep is:
- Information
about the contributors including there name, address, phone, willingness
to work for the campaign (possible things for them to do would be sending
mailings, making phone calls, holding signs, hosting a fund raising
activity)
- Information
about each contribution to the campaign including date of the contribution
and the amount of the contribution and the activity that made the
contribution happen (there should be a code for unsolicited contributions)
- Information
about the activities that generate contributions (again remember the
unsolicited) – this should include the activity name, the date, the person
in charge
Note that you need to think about primary keys and add
information to get you a meaningful private key.
Send me the design and then after we communicate implement
the design in Access.
Now I want the following queries:
- A list
of all contributors that said they would host activities
- A list
of all contributors that said they willing to send mailings OR make phone
calls.
- A list
of all contributors that said they would send mailings AND either make
phone calls OR hold signs
- All
people that gave over 1000 to the command that includes their name and the
date and amount of the contribution
- A
listing of all people who gave an unsolicited contribution
- All
contributions that came out of a particular activity that should include
the contributors name, the amount of the contribution, the date of the
contribution, the name of the activity and the date of the activity