Organizational Advice

[Jared Lui]

In this scenario, how many tables would you create and what would they contain? This is not a pop quiz, just seeing if I am on the right track or way off the mark.

Premise:
Bowling League Site

Objective:
to add weekly scores for each bowler and for bowlers to browse their scores and those of the other bowlers/teams.

Deliverables:
input page (to add bowlers scores for three games, each week)
Teams page (shows each of the teams in the league along with each bowler on the team and a few of their stats such as avg. and handicap)
detail page (gives more detail of an individual bowler)

So, I need to be able to have a page that lists all the teams and their bowlers and a few stats. When you click on a bowler you are taken to a page with their stats in full. Would also like to have a ranking page, listing things such as high bowler, high scratch, best average, etc.

With this being said, what tables would I need and what would each table (in broad terms) contain.

Your input will be most helpful.