separate tables:
breeder_line
genotype (of animal)
species - move back to animal table (field); strain w/ be included in vendor_strain table
===
new table (vendor_strain) [prev. stock number] w/ composite key (vendor_id and strain)
ref: follow Jackson labs - stock, strain, breeder_line for mother & father
separate tables:
breeder_line
genotype (of animal)
species - move back to animal table (field); strain w/ be included in vendor_strain table
===
new table (vendor_strain) [prev. stock number] w/ composite key (vendor_id and strain)
ref: follow Jackson labs - stock, strain, breeder_line for mother & father