79194 - Databases

Course Unit Page

Academic Year 2018/2019

Learning outcomes

The student learns the fundamental principles of the relational data model and of the relational database management systems. In particular, the student will be able to understand the structure of a relational database, the integrity constraints on data and the SQL query language.

Course contents

Data modelling

Concepts in order to describe and arrange data:

  • Conceptual model (Entity - Relationship diagram)
  • Logical model (relations)

Data Base management

  • Data base management systems (DBMS)

A language to query data bases: SQL

  • Data definition and manipulation
  • Query data bases

Data analysis

  • Extract data, information
  • Create data views

Data quality

Data integration

Data and text mining applications

Readings/Bibliography

Lectures are mainly based on the book: "A First Course in Database Systems" di Jeff Ullman e Jennifer Widom.

Teaching methods

Lectures will be held mainly in computer room. Special theoretical topics and seminars will be part of the course.

Assessment methods

Practical and written examination. Abilities are required in order to design a data model based on given requisites, and furthermore in order to write query a concrete data base, using SQL langugage.

Teaching tools

Personal Computer and software application aiming to manage and query relational databases.

Office hours

See the website of Damiano Marino Somenzi