Studying at the University of Verona
Here you can find information on the organisational aspects of the Programme, lecture timetables, learning activities and useful contact details for your time at the University, from enrolment to graduation.
Study Plan
The Study Plan includes all modules, teaching and learning activities that each student will need to undertake during their time at the University.
Please select your Study Plan based on your enrollment year.
1° Year
| Modules | Credits | TAF | SSD |
|---|
2° Year activated in the A.Y. 2011/2012
| Modules | Credits | TAF | SSD |
|---|
3° Year activated in the A.Y. 2012/2013
| Modules | Credits | TAF | SSD |
|---|
Due insegnamenti a sceltaUn insegnamento a scelta| Modules | Credits | TAF | SSD |
|---|
| Modules | Credits | TAF | SSD |
|---|
| Modules | Credits | TAF | SSD |
|---|
Due insegnamenti a sceltaUn insegnamento a sceltaLegend | Type of training activity (TTA)
TAF (Type of Educational Activity) All courses and activities are classified into different types of educational activities, indicated by a letter.
Database systems for bioinformatics (2011/2012)
Teaching code
4S02712
Credits
12
Language
Italian
Scientific Disciplinary Sector (SSD)
INF/01 - INFORMATICS
The teaching is organized as follows:
Teoria
Laboratorio
Learning outcomes
This course provides the student with the required knowledge for the design and implementation of databases and related applications.
In particular, attention will be paid on methodologies for conceptual and logical database design, on the implementation of databases through widely known (relational) database management systems. Both theoretical and "practical" query languages will be introduced, as relational algebra and SQL.
After an introduction of the basic concepts of computer networks, the course will deal with methodologies and technologies for the design and implementation of data-centric web sites, with an emphasis on the storage and query of bioinformatics data.
Program
* Introduction of data base management systems. Architecture and functionalities of a database system.
* Data models for database systems. The relational data model.
* Interacting with a database: languages for the definition, manipulation, and query of a database. Relational algebra. The SQL language.
* Database design. The methodology. The Entity-Relationship (ER) data model. Logical database design: the logical schema of a database. Translating conceptual schemata in relational schemata.
* The internal architecture of a database management system: the relevance of transactional systems. The ACID transaction properties. Physical data organisation: sequential data structures and indexes (B-trees and hashing).
* Data centric web applications and bioinformatics. Basic concepts of computer networks. Semistructured data models; XML for bioinformatics. Interaction of web servers and data base management systems. Design methodologies for data-centric web applications. The MVC model. Design of data-centric web-based bioinformatics applications.
Bibliography
| Activity | Author | Title | Publishing house | Year | ISBN | Notes |
|---|---|---|---|---|---|---|
| Teoria | P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi, R. Torlone | Basi di dati: architetture e linee di evoluzione (Edizione 2) | McGraw-Hill | 2007 | 978-88-386-6370-3 | |
| Teoria | P. ATZENI, S. CERI, S. PARABOSCHI, R. TORLONE | Basi di dati- Modelli e linguaggi di interrogazione (Edizione 3) | McGraw-Hill | 2009 | 9788838666001 | |
| Teoria | R. Elmasri, S.H. Navathe | Sistemi di Basi di Dati: Fondamenti (Edizione 6) | Pearson | 2011 | 978-88-7192-628-5 |
Examination Methods
The exam consists of a written examination with exercises on the different topics of the course (both theory and lab) lasting about 3 and a half hours.
