AnsweredAssumed Answered

Database design. Help!

Question asked by famtornhult on Aug 12, 2015
Latest reply on Aug 19, 2015 by richardsrussell

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?

Outcomes