How should i design a triathlete-database which should be able to store results for several hundred triathletes?
I absolutely get how I could do it but I absolutely need to be able to import results from xls to several tables.
One table should be: TriathleteID, Name, Club, Age-group.
The other: Venue, Distance, Swim, Bike, Run, Total.
I could even have 3 tables with Triathlete as one, result as second and race as relation-object.
BUT HOW AM I SUPPOSED TO IMPORT IN THE EASIEST WAY?