Result Database
Hello,
I'm currently developing a database to keep track of the results of swimming competitions. But I'm stuck with the split times
I have 1 table named results:
- ResultID
- DistanceID
- CompetitionID
- SwimmerID
- ReactionTime
- EndTime
- Remarques
Now I'm not sure how I can add the split times. Split times are recorded every 50 meters, and the maximum distance is 1500. So the maximum number of splittimes is 30.
Together with these split times, I need to keep track of the amount strokes done/50m (Don't know if stroke is the right word for it, example: Breaststroke: 1 complete movement = 1 stroke).
Can somebody help me with this problem?
Subject
Written By
Posted
Result Database
July 24, 2011 07:48AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.