Im just trying to improve my skills and I wanted to work on a personal project (no this is not a class assignment). I am an avid golfer so I want to put together a website that will track my handicap and for other members of my golfing group. I know there are similiar systems out there but I wanted to go through the process myself. Database design is a weak area for me.
requirements:
a golfer can login and view his/her handicap along with the other members of the group. The golfer can enter a round played (date specific) at any golf course listed in the system. If a course is not listed, the administrator can input the course as necessary. The golfer can enter a quick entry for the round played (front and back score) or enter detailed information e.g. score for each individual hole, putts, fairways hit, etc. The posted round will then be tabulated towards the players handicap based on formula and index system (how many rounds you played will determine what scores you can use towards your handicap).
The problem that I am having is a golf course has many tee_types (blue,white,red) with different slope and course rating values used to calculate the rounds handicap. I can not see my way through to a sound relational design? I hate getting brain farts like this any suggestions on how I should approach the design of the database for my little project?
thanks in advance,
Alex
