Database Systems
- Overview
- Assessment methods
- Learning objectives
- Contents
- Bibliography
- Teaching methods
- Contacts/Info
Programming
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.
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.