IT Final Project - Golf-a-thon
Problem: You have been asked to write a program for a local charity that has an annual golf-a-thon to raise money. The event has golfers sign up and then gather sponsors to pay them for playing in the event. The program needs to be able to add, update(edit) and delete players. It also needs to be able to add, update(edit) and delete sponsors. Don't forget when you add a player in for the current year you will have to add them into the TGolferEventYears. There are several places you will have to add records to make everything work correctly. Make sure you have this in place. The final piece is for you to display statistics.
Instructions:
1. Use the database script that is provided with FK's and limited data already entered in for you. You will need to add data as needed for your individual project. The tables are as follows
- TEventYears
- TGenders
- TGolferEventYears
- TGolferEventYearSponsors
- TGolfers
- TPaymentTypes
- TShirtSizes
- TSponsors
- TSponsorTypes
2. Use separate forms to add, update(edit) and delete both sponsors and players. You can use a search form to pull the information for a sponsor or player and then edit or delete using that form.
3. Do not allow any deletions without prompting if the user is sure they wish to delete.
4. For statistics show the amount pledged for each of the following:
a. Golfers
b. Sponsors
c. Years
d. Events
You can display these in a label, a messagebox, a listbox or any other control you choose. I just want to see the aggregates from the DB for each of the items listed above.
5. Avoid global variables, pass information or use classes, modules, and/or structures to share data.
6. If you have any questions, please email your instructor.
Attachment:- Assignment Files.rar