Master in Bioinformatics: Database Course


MASTER IN BIOINFORMATICS: DATABASE COURSE

GOALS

This course has the goal to introduce the non specialist persons to the comprehension of a relational schema and to the usage of a relational database management system.
The theoretic lessons will be always accompanied by exercises in laboratory with the usage of a system (open source) , MySql.

PROGRAM

   Introduction to databases    Slides (pdf)

   Main concepts of entity and relationship. Examples.

   The relazional model, notion of key (primary and foreign). Examples.

   Generation rules of a relational schema from a Entity-Relationship diagram. Examples.

   Introduction to SQL, the standard query language for relational databases. Examples.

   Case Study: UNIGENE data.
It contains a part (first 10000 genes) of a database of genes with organisms' tissues in which genes express themselves.

   Case Study: Description of proteins for the design of a database of proteins.

Bibliography:

Atzeni, Ceri, Paraboschi, Torlone: Basi di Dati: Concetti, Linguaggi e Architetture, McGraw Hill Libri Italia, 1999.

Luke Welling and Laura Thomson: MySQL Tutorial, MySQL Press, Pearson Education, 2004.

Devan Shepherd: XML, APOGEO, 2002.

.

Ultima versione: 25 Marzo 2004

Introduction to databases	Slides (pdf)
Main concepts of entity and relationship. Examples.
The relazional model, notion of key (primary and foreign). Examples.
Generation rules of a relational schema from a Entity-Relationship diagram. Examples.
Introduction to SQL, the standard query language for relational databases. Examples.
Case Study: UNIGENE data. It contains a part (first 10000 genes) of a database of genes with organisms' tissues in which genes express themselves.
Case Study: Description of proteins for the design of a database of proteins.