Baseball Database

[DMGoldie]

Hi All,

I am trying to create a baseball database that will allow the following:

- Track players position by inning, batter order per game, pitch count per inning

I have a file setup with players names and contact information...where should I go from here?

Thanks,

dmg

[Wim Decorte]

Hey dmg,

My favorite topic: baseball

Start from the output you want out of this and work backwards to the data tables that are required to make it work.

From what you describe you need to track data per inning per game.

Innings would be a table, child of a Games table

Players is a table

Team is a table

Season is a table

Stints is a table (join between Player, Team and Season)

and so on...

I have a pretty good baseball database but not with the amount of data you're after. I can certainly make it available as a start.

[DMGoldie]

Thanks Wim! I will play around with your suggestions.

I would love to take a look at your db - can you email it to me?

Thanks again,

dmg

[Triple]

Hey guys,

I'm looking to do a similar db. Would either of you guys be willing to share what you have done with me as well?

Thanks