Need help in creating database for a golf league

I am going to attempt to build a web site / database for the golf league
that I am in. It will be a good learning exercise and it should be fun as
well. I am not sure how to set up my tables in MYSQL. I now enough about
databases that if I do this part incorrectly that I may make my life much
more difficult.

I am going to use MySQL as my database ( I have no MYSQL experience but some
MSSQL and Access), and I will connect to it using PHP ( I have used it in
the past)
My provider offers both options for free.

Database for a golf league web site

Each player will have the following data initially loaded

First name

Last name

Email address

Phone number

Work number

Starting Handicap for the year


The following data will be loaded each week for approximately 14 weeks


The golf scores by hole for each person


For example after Larry completes 9 holes the data to be entered would be

Hole# 1 2 3 4 5 6 7 8 9
Score 4 3 4 4 5 4 4 3 4

Out of this data the code I create will calculate the following:

The players handicap based on the score(s) of the preceding weeks

Standings based on scores

Most birdies

Most Pars

Here is my question:


When I set up my database do I have my "weekly scores" in a different table
then my "golfer data"? Or would I have each "week" a separate table then
the golfer data?

Thanks for any help

Larry C

L C wrote:
> I am going to attempt to build a web site / database for the golf league
> that I am in. It will be a good learning exercise and it should be fun as
> well. I am not sure how to set up my tables in MYSQL. I now enough about
> databases that if I do this part incorrectly that I may make my life much
> more difficult.
>
> I am going to use MySQL as my database ( I have no MYSQL experience but some
> MSSQL and Access), and I will connect to it using PHP ( I have used it in
> the past)
> My provider offers both options for free.
>
> Database for a golf league web site
>
> Each player will have the following data initially loaded
>
> First name
>
> Last name
>
> Email address
>
> Phone number
>
> Work number
>
> Starting Handicap for the year
>
>
> The following data will be loaded each week for approximately 14 weeks
>
>
> The golf scores by hole for each person
>
>
> For example after Larry completes 9 holes the data to be entered would be
>
> Hole# 1 2 3 4 5 6 7 8 9
> Score 4 3 4 4 5 4 4 3 4
>
> Out of this data the code I create will calculate the following:
>
> The players handicap based on the score(s) of the preceding weeks
>
> Standings based on scores
>
> Most birdies
>
> Most Pars
>
> Here is my question:
>
>
> When I set up my database do I have my "weekly scores" in a different table
> then my "golfer data"? Or would I have each "week" a separate table then
> the golfer data?
>
> Thanks for any help
>
> Larry C
>
>

Larry,

I would suggest you start by searching on "database normalization" and
understand how normalizing works. Most databases are around 3rd normal
form (3NF).

Then take a cut at designing it, and come back here with your try.
You'll learn a lot more by figuring it out this way, and we can help you
make it more efficient.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================