Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Baseball Play-by-Play database

Posted on 2007-04-08
2
Medium Priority
?
270 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 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.
0
 

Author Comment

by:Fu2M4n
ID: 18875097
Thank you sir.

The timestamp is a great idea.
0

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.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

670 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