Baseball Play-by-Play database

Posted on 2007-04-08
Medium Priority
Last Modified: 2013-11-29
Hello Folks,

I'd like input on how you would go about designing/layout a play by play account of all the basbeall games in MLB. I really am in over my head on this one. This is my first project with access so please be gentle :)
I used excel for these types of projects but feel its time to move on to a more adequate program for this type of thing...

Each game has has approx 75-100 Events (Plate appearences, Stolen Bases, Wild Pitches etc...) per game.
Here are the tables i have so far.

Schedule - GameID (autonumber), Date, Home team, Away team.
PlayerList - Player ID(autonumber), FirstName,LastName,Bats, Throws, DOB,Position
UmpireList -UmpireID(autonumber),FirstName, LastName, Crew #
TeamList - TeamID(autonumber),TeamName, League

How would you folks go about organizing the play by play events for each GameID?
Is this one of the situations where normalization goes out the window?
Should i just have one table with all the games on it.(1600 games) listing each gameID 75-100 times with all of their respective events taking up a row?

Any advice would be greatly appreciated fellas..
Question by:Fu2M4n
LVL 39

Accepted Solution

stevbe earned 500 total points
ID: 18874904
Your plays would be a separate table that includes the GameID. You will also need to identify if the play event is for the offense or defense and you are going o need to time stamp the entry of your records (or manually enter the time of each event) so that you can *replay* the exact order.

Author Comment

ID: 18875097
Thank you sir.

The timestamp is a great idea.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Implementing simple internal controls in the Microsoft Access application.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question