GWAS Data Model

Design a Data Model

You are the manager of a bioinformatics support service and need to build a database to manage data from your users' studies. Define a data model (entities, atributes and relationships) to hold data from a series of GWAS (Genome Wide Association Studies) based on SNP-arrays data. Data should include: 1) a variable set of phenotipic traits. 2) Reference, supplier and genes included in SNP-array used in the study, 3) Sample and user details, 4) GWAS results: genes, annotations, and associated statistics, 5) References.