How to build a baseball stats database

This is a discussion on How to build a baseball stats database within the C Programming forums, part of the General Programming Boards category; My goal is to build a baseball statics database. A tree schematic would be like: Database branch to Team branch ...

  1. #1
    Registered User
    Join Date
    Aug 2008
    Posts
    12

    How to build a baseball stats database

    My goal is to build a baseball statics database. A tree schematic would be like:
    Database branch to Team branch to Game # branch to Player brach to Each individual statistic. I want to be able to search for a player and bring up his total stats, I want to be able to bring up stats for a certain team on a certain game, and I want to be able to sort stats and see what player's lead in certain categories. Any thoughts or ideas on how to begin to construct this? I was thinking of doing it with all array, but if I wanted to make a player array, how can I associate a team name, position name, and stats in one array?
    Last edited by Programmer3922; 08-01-2008 at 11:02 PM.

  2. #2
    CSharpener vart's Avatar
    Join Date
    Oct 2006
    Location
    Rishon LeZion, Israel
    Posts
    6,474
    Probably start with DB of teams
    Create the struct DB and struct Team
    Deside how you store your Team set (probably dynamic array)
    Decide what API you will provide (add new Team, search the Team by name or ID) modify Team
    Save / Load to from file

    Write it, compile it, test it

    When it is working - Add players, etc
    The first 90% of a project takes 90% of the time,
    the last 10% takes the other 90% of the time.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. PlaySound
    By cangel in forum C++ Programming
    Replies: 16
    Last Post: 10-08-2009, 05:29 PM
  2. Creating a database
    By Shamino in forum Game Programming
    Replies: 19
    Last Post: 06-10-2007, 01:09 PM
  3. Database API?
    By taelmx in forum Networking/Device Communication
    Replies: 2
    Last Post: 01-12-2007, 10:26 PM
  4. Boom, Headoshot!!
    By mrafcho001 in forum A Brief History of Cprogramming.com
    Replies: 50
    Last Post: 07-21-2005, 08:28 PM
  5. Database Software Ideas...
    By Visual Develope in forum A Brief History of Cprogramming.com
    Replies: 1
    Last Post: 05-29-2002, 02:07 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21