DBW – Databases and Web development

 

E-R Exercises

Define entities and main relationships of the data needed to deal with the following situations (Note: use MySQL workbench to draw entities-relationship scheme):

  1. Set of inhibitor data, including nature of the inhibitor compound, enzyme inhibited,  source organism, type of inhibition (reversible, irreversible, etc.), inhibition constant, and literature reference. (Solution:: mwb png)
  2. Protein-Protein interactions data. Proteins involved (include references to Uniprot and/or PDB), interaction details (permanent, transient, etc), experimental data and literature references. (Solution:: mwb png)
  3. Genotype data, about 250000 SNPs for a large number of individuals. Consider two options: a) We should get information for individual SNPs, and b) only complete haplotypes should be retrieved. (Solution::png)
  4. User management, including specific levels of privilege like administration, readwrite data, read-only, and personal preferences. The model should be open enough to be used in any application. (Solution:: mwb png)
  5. Expression analysis for a set of genes, and experimental conditions. For the stored genes should allow including annotations and references to other DBs. (Solution:: mwb png)
  6. A metabolic network, including, enzymes, metabolites and chemical processes involved. (Solution:: mwb png)