Help Needed

MrBLT

Registered User.
Local time
Today, 08:15
Joined
Oct 2, 2003
Messages
20
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
 
does this question make sense or am i asking for too much
 
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.
 

Users who are viewing this thread

Back
Top Bottom