Re: Database design for scientific tests
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.
Subject
Views
Written By
Posted
4304
June 22, 2009 06:44PM
2003
June 24, 2009 08:27AM
2087
June 24, 2009 09:24AM
1908
June 24, 2009 12:00PM
1713
June 24, 2009 02:20PM
1621
June 24, 2009 02:43PM
1907
June 24, 2009 03:46PM
1948
June 24, 2009 06:05PM
2145
June 25, 2009 09:41AM
Re: Database design for scientific tests
1485
June 25, 2009 12:34PM
2135
June 25, 2009 02:01PM
1760
June 25, 2009 02:28PM
2081
June 25, 2009 02:53PM
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.