Figure 2

Relational design Relational design of GeneLink's 11 primary tables. Primary keys are indicated in red and foreign keys in blue. GeneLink enables pedigree information stored in the Families and Pedigrees tables to be easily merged with genotypic data stored in the Genotypes table. In the Pedigrees, Liability Classes, Trait Score, and Trait Translation tables GeneLink also manages extensive phenotypic data. The Markers and Primer tables store information regarding polymorphisms being genotyped and the Maps table stores genetic or physical map information, which determines the order in which data is exported. GeneLink's Primer and DNA tables provide labs with an easily implemented inventory system.