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 ONE of the following cases:
A series of RNAseq (analysis). Data should include:
1) Genes included in the study.
2) Reference, suppliers, for sequencing reagents and equipment used.
3) Sample and user details.
4) Results: genes, expression values, differential expression analysis.
5) References.
Following, an image of the data model has been added. The colors of each one represent one of the objectives:
1) Dark green:Genes included in the study.
2) Dark Cyan: Reference, suppliers, for sequencing reagents and equipment used.
3) Cyan: Sample and user details.
4) Green: Results: genes, expression values, differential expression analysis.
5) Dark blue: References.
6) Gray: Extra data tables added to convey better the information of the data model.