Baseball DB by Game and By Inning

[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

[Weetbicks]

A filemaker file setup with contact info, or just a plain old text file?

 

I would recommend reading some books on FileMaker cos it sounds like you are coming to it brand new with that kind of question. "Using FileMaker 9" is a great book to read, available @ amazon.

 

Theres really not much I can say because I'm not sure if yer asking how to build the whole thing, or training materials you can read etc... What is your filemaker knowledge? database knowledge? relational database knowledge?

[DMGoldie]

Weetbix,

 

I am embarrassed to say this but I have been working with FileMaker since 2.1 - and for a while I was developing fulltime for a living. The problem is over the years I haven't really worked with a ton of many-to-many issues.

 

I already have the player db finished - player info, tryout ratings and drafting ordered. With the season a week away I thought I would play around with tracking the kid's positions and pitch count by inning...but I just can't seem to get my head around it.

 

I created a "game" table and an "inning" table but how to I relate/display the kids playing in a game - and their stats by inning?

 

Thanks,

 

dmg

 

A filemaker file setup with contact info, or just a plain old text file?

 

I would recommend reading some books on FileMaker cos it sounds like you are coming to it brand new with that kind of question. "Using FileMaker 9" is a great book to read, available @ amazon.

 

Theres really not much I can say because I'm not sure if yer asking how to build the whole thing, or training materials you can read etc... What is your filemaker knowledge? database knowledge? relational database knowledge?

[D J]

- 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?

 

Players, Innings and Games are a good start for tables.

 

For position by inning, a Fielder Inning Join table would be good. Each record will be an inning, a player, and a position, with an order field in case of a mid-inning switch.

 

For pitch count, I'd use a separate table, Fielder Pitcher which would link to the pitcher records in the Fielder Inning Join. Each record would be a a pitch count and maybe # outs and pitching order (for those times when you switch pitchers mid inning). Or maybe a running count of pitches (a start pitch and end pitch) instead of outs and pitching order.

 

For batting order...if you just want to keep track of order (and no stats), a Batter Game Join is all you need. Each record is a player, a game, and the batting order, in absolute terms (in the 7th inning, the SS was the 30 batter), you can do a Mod(x;9)+1 to get the order in the line up.

 

Of course, a player can pinch hit in the middle of a count, so, uh, stick an Order field in there which will almost always be 1 except for that case, when you throw a 2 in for the pinch hitter? Seems a cheapo way out, but easier than atomizing the db down into pitches (which you should do if you're trying to get actual stats).

 

So in short, Players, Innings, and Games plus:

Fielder Inning Join

Fielder Pitcher

Batter Game Join