Unit | Credits | Academic sector | Period | Academic staff |
---|---|---|---|---|
Laboratorio | 2 | INF/01-INFORMATICS | 3° Q |
Barbara Oliboni
|
Teoria | 6 | INF/01-INFORMATICS | 2° Q |
Barbara Oliboni
|
Module: Teoria
-------
This unit introduces issues related to the design of a databases by considering both logical data models and conceptual data models.
Moreover, the unit introduces the SQL query language.
Module: Laboratorio
-------
This unit introduces issues related to the use of a Database Management System (DBMS) for creating, managing, and querying a database.
Module: Teoria
-------
* Introduction to the database management systems
* Logical design of a database
-- The relational data model
* Relational algebra
* SQL
* Conceptual design of a database
-- The Entity-Relationship data model
-- From conceptual schemata to relational schemata
* DBMS Architectures
Module: Laboratorio
-------
* Introduction to the PostgreSQL DBMS
-- Database connection
-- Simple checking commands
-- Tables creation
* PostgreSQL
-- Integrity constraints
-- Reaction policies for referential integrity constraints
-- Simple SQL queries
-- Complex SQL queries
* The HTML language
-- The structure of HTML documents
-- Main tags
-- Tables
-- Form
* Biological Databases
* Introduction to implementation of web applications
Module: Teoria
-------
Module: Laboratorio
-------
Author | Title | Publisher | Year | ISBN | Note |
P. Atzeni, S. Ceri, P. Fraternali, S. Paraboschi, R. Torlone | Basi di dati. Architetture e linee di evoluzione | McGraw-Hill | 2003 | 88-386-603 | |
P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone | Basi di dati, modelli e linguaggi di interrogazione | McGraw-Hill | 2002 | 8838660085 | |
E. Baralis, A. Belussi, G. Psaila | Basi di dati - Temi d'esame svolti (Edizione 1) | Progetto Leonardo Società Editrice Esculapio Bologna | 1999 | B135655713 |
******** CSS e script comuni siti DOL - frase 9957 ********p>