Finally getting around to finishing a project that I am developing for my use. I want to put together a website (php/mysql) to track golf handicaps for me and my fellow hackers.
I put together an ERD but I am having problems (see atached file). (I am still trying to improve on my database design skills)
The requirements:
A registerd golfer may enter a round of golf at x golf course played on a certain date. The golfer can enter their round either by a quick or detailed entry. The handicap score is then calculated by taking the rawscore, the specific tee type slope and rating values, in a specified formula. The average of a rolling ten handicap scores will determine the golers handicap.
The quick entry method will take the front and back scores and sum them for a rawscore.
The detailed entry will allow a golfer to enter individual scores for each hole, including fairways hit, greens in regulation and total putts. The sum of the total scores for each hole for the round played will be calculated to determine the rawscore.
The way I have my design set up now is fine for a quick entry but get's a little messy (code wise) for the detailed entry. In my design I need the round played (rp) id for the hole details (hd) recordset. Problem is with the rawscore. It would initially have to be an arbitrary number until each of the hole details can be summed then updated to that specific round played recordset because of the dependency issues between the two tables.
If there is a different design suggestion I would appreciate your response.
Thx
Alex
