Political Contribution Database

I would like you to create another database. Since we are in a political season, 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 (your choice whether you use 2007 or 2003).

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