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 proteomics analysis. The data shoud include the following
Sample and user details.
Experimental protocols used.
Protein sequences found.
Identified proteins from sequences.
References.
Some things:
The experimental protocol has a reference if these protocols come from other articles. If not, the reference and the experimental_protocol_has_experimental_protocol_reference would not be necessary. Anyway, a table describing the protocol would be necessary.
In all the tables, there is the relevant_metadata. This could be amplified to as many fields or features as found necessary.