Question: A high school wants to hold a fundraiser called a golfathon. They asked you to create a database to do such a thing. This database
A high school wants to hold a fundraiser called a golfathon. They asked you to create a database to do such a thing. This database must be able to store the golfers information, when they played (what year), who their sponsors are per year, and what sports team they played for per year. Your job is to build a scalable normalized database. Below is some information that you might need to build your database.
Things that will be required:
Total amount sponsored per each years event
Golfers playing per year
How many years the golfers have played thus far.
Leading sports team
Leading money sponsored golfer per year
Sponsorships per golfer year
Total collected per golfer per year
Sponsorships per sports teams per year per level
Some information that you may need to know:
Golfer Information Needed:
Name
Address
City
State
Zip
Phone Number
Shirt Size
Sponsors
Name
Address
City
State
Zip
Phone Number
Date of sponsor
Sponsor Amount per hole
Type of Sponsor (cash, credit, check)
Pay Status (paid, unpaid)
Teams Golfers could play for
Type of Team (basketball, soccer, football, volleyball, etc.)
Level of Team (Freshman, JV, Varsity)
Gender of Team (Boys, Girls)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help