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 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.

...