Solved

Baseball Play-by-Play database

Posted on 2007-04-08
2
257 Views
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..
Thanks
0
Comment
Question by:Fu2M4n
2 Comments
 
LVL 39

Accepted Solution

by:
stevbe earned 125 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.
0
 

Author Comment

by:Fu2M4n
ID: 18875097
Thank you sir.

The timestamp is a great idea.
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

820 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