MySQL Forums
Forum List  »  MySQL Workbench

Re: Database design for scientific tests
Posted by: Al Lombardo
Date: June 25, 2009 12:34PM

The reason why I broke out the test_data_type into another table was because it seemed that each test was going to track different data. Really, the proper was to handle this is to have it all in one record, so instead of having a fk to a lookup table, just have a column for each possible type, pressure, temp etc. If you aren't interested in keeping data for temp then just leave it null.

Options: ReplyQuote

Written By
Re: Database design for scientific tests
June 25, 2009 12:34PM

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.