Help Needed

[MrBLT]

Hey everyone. Can someone give me directions on primary keys and foreign keys for my tables. This is my first ever database and pretty clueless on what to do. It's to keep track of the nba scores. I don't even know if the tables are right.
The tables are as follows

Date
Team
Score
Line
Home/Away
W/L game
W/L ATS

1st Qtr
2nd Qtr
3rd Qtr
4th Qtr

FG Made
FG Attempt
3pt made
3pt attempt
free throw made
free throw attempt
rebound
fouls
assist
block
steals
turnover

Thanks

 

[MrBLT]

does this question make sense or am i asking for too much

 

[Pat Hartman]

I looked at the question but didn't answer it because I don't follow sports so I am not familiar with the statistics gathering process. Because of that there are simply too many questions in my mind. As a general critique, I would say you have designed a spreadsheet rather than a relational table. You should have at least two tables, possibly three if the stats are kept by quarter. I think the stats should be stored vertically rather than horizontally. That way it will be easier to manipulate them with queries. So rather than having fields with names like: FG Made
FG Attempt
3pt made
3pt attempt
You would have a column named - StatTypeID and it would identify the stat. So the data would look like:

GameID, StatTypeID, StatValue
1, 1, 5
1, 2, 2
1, 3, 0

Also when deciding on column and table names, avoid the use of Access functions, especially "Date" and do not use embedded spaces or special characters such as "/".

 

[MrBLT]

Thank You for your reply Pat. You have given me some ideas. Has anyone on this forum built a sports database or know anywhere i can go for more help. If it helps i'm trying to create a database so i can put it on a website as like this site

http://www.covers.com/data/nfl/game/g1_10200.html
although this is football and not basketball the way the numbers are placed is what i'm after.