Course Details for A.Y. 2018/2019

The information on this page refer to the academic year 2018/2019. Therefore, several links are not available and data may be incomplete. To read the current information on the course, if it is still available, go to the university course catalogue . To read information relating other academic years, use the list at the bottom of this page.

A. Year:

2018/2019

Name:

Database Systems / Database Systems

Type:

Course

Basic information

Code:

DT0347

Sector:

INF/01

Credits:

: Master Degree in Applied Data Science 6 CFU (c)

Term:

1^st semester

Degree(s):

Master Degree in Applied Data Science 1^st anno curriculum Data for Smart City Compulsory
Master Degree in Applied Data Science 1^st anno curriculum Data for Life Science Compulsory

Language:

English

Teacher(s):

Davide Arcelli

Course Objectives

This course aims at providing practical knowledge and competences about database systems. After a brief introduction to database systems and their architectures, the course turns to data modelling through the Entity-Relationship model. Then, a brief overview of the Boolean algebra is provided, in order to introduce students to SQL essential aspects. The latter consist of introducing data types and definition, and training students on basic SQL constraints and queries, as well as insert/delete/update operations. Afterwards, SQL advanced aspects are provided, such as complex queries, triggers, views and modification of a database schema. Finally, the course introduces database programming, illustrates limitations of traditional database systems and provides knowledge about XML and JSON data formats.

Course Content

Introduction to database systems and architectures.
Usage of the Entity Relationship model for data modelling.
Boolean Algebra.
SQL essential aspects: data types and data definition, basic SQL constraints and querying, insert/delete/update.
SQL advanced aspects: complex queries, triggers, views, database schema modification.
Introduction to database programming and advanced aspects: limitations, XML and JSON data formats.

Assessment Methods and Criteria

The exam of the Database Systems course is composed of a mandatory written test and an optional oral test. The oral test can be required: by the student in order to improve grades; by the teacher in case the student's written test has serious omissions or mistakes.

Textbooks

Elmasri Ramez And Navathe Shamkant, Fundamentals of Database Systems , Pearson. (vol. 7th edition) 2016.

Course page updates

This course page is available (with possible updates) also for the following academic years:

To read the current information on this course, if it is still available, go to the university course catalogue .

Course information last updated on: 10 settembre 2018, 16:38