- Docente: Damiano Marino Somenzi
- Credits: 6
- SSD: ING-INF/05
- Language: English
- 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
Comprehend Web data
Data modelling
Main concepts to describe and arrange data:
- Conceptual model (Entity - Relationship diagram)
- Logical model (relations)
Database management
- Database management systems (DBMS)
A language to query data bases: SQL
- Data definition and manipulation
- Query databases
Data analysis
- Extract data, information
- Create data views
Data mining applications
Data integration
Readings/Bibliography
Lectures wil be mainly based on the book of Jeff Ullman and Jennifer Widom: "A First Course in Database Systems". Further readings, examples and exercises will be made available on “Insegnamenti Online”.
Teaching methods
Lectures will be held mainly in computer room. Special theoretical topics and applications will be part of the course.
Assessment methods
Practical and written assessment. Abilities are required in order to design a data model based on given requisites, and further to write queries on a real database through SQL language. The assessment includes exercises and/or questions on course contents.
Teaching tools
Personal Computer and software to manage and query relational databases (MySQL) and software for data analysis (R).
Office hours
See the website of Damiano Marino Somenzi