Baseball Play-by-Play database

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
Fu2M4nAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

stevbeCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Fu2M4nAuthor Commented:
Thank you sir.

The timestamp is a great idea.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.