Designing an NBA database

[supersub15]

I am not a complete Access newbie, but I am having trouble figuring
out how to design a database for the upcoming 2007-2008 NBA season.

What I want to do is enter the box score of every game in a table and
generate a bunch of stats from the totals. For an example of a box
score, take a look here (http://sports.espn.go.com/nba/boxscore?
gameId=270521008). Since there are 30 teams and each team plays 82
games, this is not as easy as it sounds (at least not for me). If I
enter all the box scores in the same table, how do I separate the team
stats from the individual stats? how do I separate one box score from
the next? Do I enter each box score in its own table (this sounds like
a nightmare)?

Any pointers, ideas, etc.?

Thanks
Carlos

 

[Jason Lepack]

First glance gives me a structure that looks like this.

Players:
the basis
Teams:
a team has many players
a player has only one team
Games:
there are two teams in a game (home, away)

Now as far as the statistics are concerned, if you have a fixed set of
statistics that you are going to track, then you would have a single
record for each player that played in each game. the fields in the
statistics table would be the statistics that you are tracking.

I've done this for a hockey pool before, so I understand what you're
going thorugh.

Cheers,
Jason Lepack

PS: If you are setting up a page scraper then the USA Tday website is
better.

 

[supersub15]

Thanks for the answer, Jason. I got the players vs. team part. That is
the easy part. But I still have no idea how to set up the box scores
in order to feed data to the player record, then to the team record.

PS: Thanks for the USA Today idea. I'll check it out.

Carlos

 

[Douglas J. Steele]

While not directly applicable, see whether the Athletes and Teams model at
http://www.databaseanswers.org/data_models/index.htm provides you with any
ideas. (There may be other models on that page that are applicable too,
which is why I'm sending you to that page, rather than directly to the model
in question)

 

[supersub15]

OK, I thought of something and would like confirmation. Let's say
Toronto is playing against Atlanta on November 16, 2007. If I add a
couple of columns whereby all box score information for that matchup
is made specific, then maybe I can make this work.

Example: Toronto plays against Atlanta on November 16, 2007

Matchup...........................Team......Player.........etc.
16Nov1007TorontoAtlanta...Toronto...Chris Bosh..etc.
....all Toronto players, then

16Nov1007TorontoAtlanta...Atlanta...Tyrone Lue...etc.
....all Atlanta players

Is this an acceptable design?