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

Email

Shirt Size

Sponsors

Name

Address

City

State

Zip

Phone Number

Email

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)