Database Systems

Degree course: 
Corso di First cycle degree in COMPUTER SCIENCE
Academic year when starting the degree: 
2016/2017
Year: 
2
Academic year in which the course will be held: 
2017/2018
Course type: 
Compulsory subjects, characteristic of the class
Credits: 
9
Period: 
First Semester
Standard lectures hours: 
80
Detail of lecture’s hours: 
Lesson (64 hours), Laboratory (16 hours)
Requirements: 

Programming

Final Examination: 
Orale

The students learning extent is assessed through a written exam which lasts approx. 2.5 hours. Students are not allowed to consult any text book or other learning material during the test. The test is divided into two parts. The first part consists of 5/6 open questions on the conceptual aspects of the course, whereas the second part consists of three exercises: two exercises on SQL (one on the DDL part and the other on the query language) and one on database design. The grade of each part is given in thirtieths. The overall grade is determined by the following formula: 1/3 * grade of the first part + 2/3 * grade of the second part. The exam is passed if the student obtains a grade greater than or equal to 18 in both the parts.

Assessment: 
Voto Finale

The course has the goal of illustrating the models, languages, and tools for the use, the design and the implementation of relational databases as well as for the design and coding of applications that interact with a relational database.

1. An introduction to database and Data Base Management Systems
2. The relational model
3. SQL language: DDL commands
4. SQL language: DML commands
5. SQL language: contraint specification, views
6. SQL & programming languages
7. Transaction management
8. Database design

B. Catania, E. Ferrari, e G. Guerrini.Sistemi di Gestione Dati: Concetti e Architetture, Città Studi Edizioni, 2006.

B. Carminati, A. Maddalena, M. Mesiti. Sistemi di Gestione Dati (Esercizi),Città Studi Edizioni, 2008.

Slides and additional material is available on the e-learning web site.

Lectures and Exercise classes on a commercial DBMS.

During the period in which the course is held, students can meet with the instructor on class days. In the remainder of the year, students need to contact the instructor by email to set up an appointment.

Professors

ALBERTINI DAVIDE ALBERTO