Solved

Baseball Play-by-Play database

Posted on 2007-04-08
2
265 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

623 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