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
4189
June 22, 2009 06:44PM
1926
June 24, 2009 08:27AM
2021
June 24, 2009 09:24AM
1844
June 24, 2009 12:00PM
1662
June 24, 2009 02:20PM
1559
June 24, 2009 02:43PM
1851
June 24, 2009 03:46PM
1894
June 24, 2009 06:05PM
2080
June 25, 2009 09:41AM
Re: Database design for scientific tests
1415
June 25, 2009 12:34PM
2083
June 25, 2009 02:01PM
1698
June 25, 2009 02:28PM
2009
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.