MySQL Forums
Forum List  »  MySQL Workbench

Re: Database design for scientific tests
Posted by: Al Lombardo
Date: June 24, 2009 02:43PM

First, in the initial_conditions table, this would be just a list of the initial conditions you want to track, so the value field belongs in the initial_test_conditions table.

In the test_data table, the test_data_type field could be a FK referencing a list of types of things you're tracking like temperature, pressure, luminosity.

Also it looks like you're tracking multiple temperatures which may be solved by adding a time field or counter as part of the key for each measurement. This allows multiple temperature entries for a test on a sample.

Hope this helps. These things always get more complicated as you progress...

Options: ReplyQuote

Written By
Re: Database design for scientific tests
June 24, 2009 02:43PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.