Sport database:basketball

[MrBLT]

Can someone tell me if i'm on the right track. After doing some reading on Access, this is what i have come up with. This is a basketball database that i will transfer to put onto a website.

GameID(pk)
TeamID
Venue
ATS

GameID
TeamID
1st qtr score
2nd qtr score
3rd qtr score
4th qtr score

gameid
teamid
fg made
fg attempt
3pt made
3pt att
ft made
ft att
reb
foul
assist
block
steal
turnover

Just a few extra questions
1. For my first table, is there any way to have two teams in the same table(ie on for home and the other visitor)
2. If i link a database to a website, does that mean when the data changes in my database it will automatically change on the website

 

[namliam]

1. If you have 1 table ... Listing all the teams you can the link that to both the home and away of a game... no problem
2. no idea sorry...

3. wouldnt you want to know FG attempts and such per player?

Regards

The "also basketball playing" Mailman

 

[HockeyNut]

2. As long as you configured your ASP, or whatever other connection technology you are using, then yes, it would update fine.
3. That depends on the level of detail in the spreadsheet. Whenther he's taking it to player level, or just analysing teams.

HN

 

[MrBLT]

Thanks namliam
Thanks hockeynut. do you follow some form of hockey
I am only going to the team level of statistics as it would be to time consuming to enter player statistics.
do you guys follow sports of any kind.

 

[namliam]

A qoute from my previous post ...

The "also basketball playing" Mailman

Regards