Re: Design of peculiar relationship
Posted by: Peter Brawley
Date: November 26, 2014 11:45AM

tissue_sample( tsid primary key, location, species )
tissue_sample_component( tscid primary key, tsid references tissue_sample(tsid) )
dna_sample( dnaid primary key, tsid )

If you sometimes mix samples from different locations or species, you need to move such columns down to the components table.

Options: ReplyQuote


Subject
Written By
Posted
November 26, 2014 09:30AM
Re: Design of peculiar relationship
November 26, 2014 11:45AM


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.