Hi Salman,
will this achieve your needs?
peptide_table
primary_key
name (ie, Peptide1,
Peptide2)
mass
fragment_table
primary_key
name (ie, A, Q,
K)
link_table
primary_key
peptide_id
fragment_id
it gives you easy access to peptide mass and it allows you to link multiple
fragm
On 6/14/07, Salman Tahir <[EMAIL PROTECTED]> wrote:
Any help on how best to structure such data would be mostly appreciated.
See: http://en.wikipedia.org/wiki/Database_normalization
*** Grossly oversimplified example follows ***
CREATE TABLE PEPTIDE(
NAME TEXT PRIMARY KEY
);
CREATE TABLE FR
