How to design my sports database

[chemmiah]

Hello all,

I have a sports database that is in excel and I want to convert over to access:
The data is list like this for each team:



Team B:

Game Date Team rank score Opponent team rank Opponent Home/Away/Neutral Quality score
11/28/08 16 87-88 10 Team A H -0.55
11/30/08 16 90-48 226 Team C H 3.44
12/4/08 18 57-54 26 Team D A 0.333
and so on

What i want to do is have the best design so that in the future i can find the W/L record based on team, conference OR based on other criteria.
Should i list the scores w/dates in one table or should each team get its on table?

[rpeare]

in terms of a data structure I would say

tblTeams
TeamID  TeamName
1       Team A
2       Team B
3       Team C

tblSeason
SeasonID  SeasonDesc
1         Spring 2014
2         Summer 2014

tblSchedule
Sched_ID  SeasonID  GameDate
1         1         1/1/2014
2         1         1/2/2014
3         1         1/5/2014

tblGameScores
GS_ID  GameID  TeamID  TeamScore
1      1       2       5
2      1       3       4

Something in this vein.

alternately you could do something like this

GS_ID  GameID  WinTeamID  WinTeamScore  LoseTeamID  LoseTeamScore
1      1       2          5             3           2

this would be a non-normalized structure (at least to me) and may be harder to work with depending on how into your metrics you are beyond simple win/loss records.