Politecnico di Torino
Politecnico di Torino
   
Login  
it
Politecnico di Torino
Academic Year 2015/16
14AFQPL, 14AFQMQ, 14AFQPD, 14AFQPI
Database
1st degree and Bachelor-level of the Bologna process in Engineering And Management - Torino
1st degree and Bachelor-level of the Bologna process in Mathematics For Engineering - Torino
Master of science-level of the Bologna process in Cinema And Media Engineering - Torino
Espandi...
Teacher Status SSD Les Ex Lab Tut Years teaching
Baralis Elena Maria ORARIO RICEVIMENTO PO ING-INF/05 38 30 12 0 18
Farinetti Laura ORARIO RICEVIMENTO RC ING-INF/05 42 26 12 0 15
SSD CFU Activities Area context
ING-INF/05 8 F - Altre attività (art. 10) Abilità informatiche e telematiche
Subject fundamentals
The course, compulsory for the Bachelor degree in Industrial engineering and management, is offered on the 1st semester of the 2nd year. The course presents database management systems and introduces both database design methodologies and the development of applications for database querying and management. Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.
Expected learning outcomes
- Knowledge of the main characteristics of a database management system
- Knowledge of the structure and properties of the relational model
- Knowledge of query languages for a relational database: Relational algebra and SQL language
- Ability to write queries in the relational algebra and SQL languages
- Knowledge of the conceptual Entity-Relationship model for data representation and of the methodology for conceptual and logical design of a relational database
- Ability to design a relational database
- Knowledge of the SQL statements for view management, data access control, and transaction management
- Knowledge of active database systems and SQL statements for trigger definition.
- Ability to write triggers in the SQL language.
- Knowledge of the interaction techniques between SQL statements and programming languages
- Ability to design an application accessing a database
Prerequisites / Assumed knowledge
Basic programming skills.
Contents
Class topics and their weight in credits:
- Characteristics of a database management system (0.2 cr.)
- Characteristics of the relational model (0.2 cr.)
- Relational algebra (0.4 cr.): main operators and query definition
- SQL language: statements for data definition and processing (1 cr.)
- Conceptual data model (Entity-Relationship) and methodology for the conceptual and logical design of a relational database (0.8 cr.)
- SQL language: statements for view management, data access control, and transaction management (0.6 cr.)
- SQL for applications: client-server architectures, integration of SQL statements into a programming language, stored procedures, design of a client-server architecture accessing a database (0.6 cr.)
SQL language: statements to define triggers (0.4 cr.)
Delivery modes
The course includes lectures in the classroom, whose topics are described earlier, and practices on the lecture topics, and in particular SQL language, relational algebra, and conceptual and logical database design (1.8 cr.). Students will prepare an individual written report on the exercises proposed during the course. The report will contribute to the final exam grade. The course includes laboratory sessions on the SQL language and the design of a client-server architecture accessing a database (2.0 cr.). Laboratory sessions allow experimental activities on the most widespread commercial and open-source products.
Texts, readings, handouts and other learning resources
The reference book, covering the majority of the course topics, is: Atzeni, Ceri, Paraboschi, Torlone, "Basi di dati - Modelli e linguaggi di interrogazione", 3 ed., McGraw Hill, 2009.
The following book supports practices: Baralis, Belussi, Psaila, "Basi di dati: temi d’esame svolti", Esculapio, 2000. Copies of the slides used during the lectures, examples of written exams and exercises, and manuals for the activities in the laboratory will be made available. All teaching material is downloadable from the course website or the Portal.
Assessment and grading criteria
The exam includes a written part and the evaluation of the report on the individual practices assigned during the course. The written part includes questions and exercises on the main course topics (relational model, relational algebra, SQL language, conceptual and logical database design). The final exam grade is defined by evaluating both the written part and the report.

Programma definitivo per l'A.A.2015/16
Back



© Politecnico di Torino
Corso Duca degli Abruzzi, 24 - 10129 Torino, ITALY
WCAG 2.0 (Level AA)
Contatti