Title Basi di dati Databases Degree Corso di Laurea Magistrale in

Title
Basi di dati
Databases
Degree
Corso di Laurea Magistrale in Ingegneria
Gestionale (DM 270/04)
Teacher: Andrea Schaerf
Year
1
Teaching
Period
2
Credits
6
Academic year: 2014/2015
Objectives:
The course provides fundamental concepts and methodologies regarding databases and their management systems
(DBMS)
Acquired skills:
- - Familiarity with databases and database management systems
- - Knowledge of the relational database model
- - Familiarity with relational database management systems
- - Ability to design and implement large databases
- - Ability to interact with databases through the SQL language
- - Ability to use a DBMS
Lectures and exercises
Topics
hours
Specific contents
Introduction to databases
Information systems, information and data. Databases and management
systems. Dat models.
2
The relational model
Mathematical bases of the relational model. Structure and integrity
constraints of the relational model.
4
Relational algebra
Algebra operators. Queries in relational algebra.
6
The language SQL
Data definition in SQL. Query in SQL. Data manipulation in SQL. SQL
embedded in a programming language.
12
Conceptual design
The Entity-Relationship (ER) model. Design strategies. Qualities of a
conceptual scheme. Examples.
6
Logical design
Restructuring of ER models. Translation of restructured ER schemes in the
relational model.
4
Database normalization
Redundancies and anomalies. Functional dependencies. Normal forms:
3NF and BCNF. Properties of the decompositions.
6
Use of the DBMS PostgreSQL
Installation and use of PostgreSQL (v.9). Use of the client PgAdminIII.
PostgreSQL features.
2
Laboratory on SQL
Data management and query in SQL using PostGreSQL
6
Database access through the web
The language PHP. Interaction of PHP and PostgreSQL.
2
Total hours for lectures and exercises
50
for exercises only
8
Further educational activities
Labs
hours
10
Tutorials / Seminars
Workshops
Guided tours
Total hours for further educational activities
10
Total hours
60
Type of exam: Written and oral
References:
Atzeni, Ceri, Paraboschi, Torlone. Basi di dati - Modelli a linguaggi di interrogazione (4a edizione). McGraw-Hill Italia.
2013.
Additional material or information on line http://www.diegm.uniud.it/schaerf/BasiDati/
1