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
4064
June 22, 2009 06:44PM
1856
June 24, 2009 08:27AM
1960
June 24, 2009 09:24AM
1772
June 24, 2009 12:00PM
1591
June 24, 2009 02:20PM
1502
June 24, 2009 02:43PM
1763
June 24, 2009 03:46PM
1841
June 24, 2009 06:05PM
2015
June 25, 2009 09:41AM
Re: Database design for scientific tests
1341
June 25, 2009 12:34PM
2022
June 25, 2009 02:01PM
1620
June 25, 2009 02:28PM
1950
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.