Hi, I am chasing my tail here trying to figure out the best table design to store analytical data. A brief example is below. For 1000's of samples, duplicate analysis can be carried out on the same sample at different times. Each analytical run measures readings (up to 100) for up to 8 different component types. Readings from each run are used to produce statistics for each component (min, max, average, st dev etc). Someone had suggested storing individual readings for each component as a string but that just seems plain wrong to me.
Any ideas on how best to break this up into tables? Thanks