Design of peculiar relationship
Posted by:
Chr Ver
Date: November 26, 2014 09:30AM
Hello,
I'm pretty new to designing databases, and i'm encountering a problem:
In a lab, DNA samples are prepared from tissue samples. These tissue samples have attributes such as species and location. It is possible however that different tissue samples are mixed before DNA sample preparation.
So, there are 3 tables, with following attributes:
Tissue_sample:
- ID
- location
- species
Mixed_tissue_sample:
- ID
- tissue samples which are mixed together
DNA sample:
- ID
- tissue_sample OR mixed_tissue_sample
It should be possible to retrieve all tissue samples from which a DNA sample is prepared.
What is the most elegant way to fit this into a database? And is possible to do this in the MySQL workbench?
Subject
Written By
Posted
Design of peculiar relationship
November 26, 2014 09:30AM
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.