Bowling database

bowling database sql

I'm creating a MySQL database to keep track of bowling scores. It is a three-table database that should contain everything I need it to.

These are a couple of sample questions that I'd like to able to answer with the data: When I get a strike, what is the average score for that frame? If I start a game with three marks (strikes and/or spares), what is the average score for the entire game? How often to I pick up a spare when my first ball scores 5 or less?

Here's how I have it set up:

Table 1: Players
First Name
Last Name
Average
PlayerID

Table 2: Games
Player ID
Month, Day, Year
City, State
Final Score
GameID

Table 3: Frames
FrameID
GameID
Frame No.
Ball 1 score
Ball 2 score
Ball 3 score (if frame 10)
Strike (yes/no)
Spare (yes/no)
Frame score (if spare or strike, include next ball(s))

Now I just need to enter the data from the last five weeks of bowling, and learn how to write SQL queries to pull the data to answer questions like the ones above.

I just realized I didn't create an column for splits. I guess I'll have to do without for now. I'm not sure I can go back and see where I had gotten splits during last few games, anyway.