- Docente: Damiano Marino Somenzi
- Credits: 6
- SSD: ING-INF/05
- Language: Italian
- Teaching Mode: Traditional lectures
- Campus: Bologna
- Corso: First cycle degree programme (L) in Statistical Sciences (cod. 8873)
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
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