I have a database design problem which I need some help with.
I am developing a database to store some engineering lab test results. But the main problem I am running into is that each
Test is completely different from each other in terms of inputs and results. For example,
Measurement1 at three different
Measurement2 at five different
If I am running multple
Tests on sample, what is the best way to go about it?
I can create independent tables for each
Testand address this in the interface code.
I can have a normalized database with
Resultstable. Store the columns required for all the
Testsin there, eventhough some will be empty for a particular
Any help on this is much appreciated. Thanks.