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
4184
June 22, 2009 06:44PM
1918
June 24, 2009 08:27AM
2018
June 24, 2009 09:24AM
1841
June 24, 2009 12:00PM
1658
June 24, 2009 02:20PM
1555
June 24, 2009 02:43PM
1846
June 24, 2009 03:46PM
1891
June 24, 2009 06:05PM
2075
June 25, 2009 09:41AM
Re: Database design for scientific tests
1412
June 25, 2009 12:34PM
2079
June 25, 2009 02:01PM
1691
June 25, 2009 02:28PM
2007
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.