Table Design Specific

[RustyRick]

I need a table to collect the score from one competitor single sitting.



He gets 20 shots in the given time frame. I need to collect the score of each shot numbered 1 to 20.

So I'm thinking I need 20 records in one table.

Is there a better simpler way?

[June7]

20 records sounds like proper normalization. Would could be simpler?

I hope you don't mean a table for each competitor and each sitting.

[RustyRick]

Noone record with 20 fields

[June7]

That is not a normalized structure. Makes it harder to do statistical analysis (sum, average, maximum, minimum).

[RustyRick]

Ah OK I think I've got the idea. 1 record or row for each shot. That makes sense.