Politecnico di Torino
Politecnico di Torino
   
Login  
it
Politecnico di Torino
Academic Year 2007/08
07AFQBT, 07AFQBW
Database
1st degree and Bachelor-level of the Bologna process in Information And Communication Technologies Engineering - Torino
1st degree and Bachelor-level of the Bologna process in Information And Communication Technologies Engineering - Torino/Grenoble
Teacher Status SSD Les Ex Lab Tut Years teaching
Rebaudengo Maurizio ORARIO RICEVIMENTO O2 ING-INF/05 2.5 1 0.5 0 8
SSD CFU Activities Area context
ING-INF/05 4 B - Caratterizzanti Ingegneria informatica
Objectives of the course
Students improve the knowledge of databases in terms of conceptual design and management rules; they get competence about the relational model and learn the basic concepts for developing a data-based system.
Syllabus
Relational model - Relational algebra
SQL: data definition language and data management language
Transactional systems and failure management
Mention about previous database models and object model
Conceptual data model - Entity/Relationship model
Techniques for designing a conceptual schema
Techniques and tools for designing a logical-relational schema
Basics about normalization theory
Laboratories and/or exercises
Students design simple databases and perform SQL exercises directly with PC
Bibliography
Atzeni, Ceri, Paraboschi, Torlone, Basi di dati, 2a ed., McGraw Hill, 1999
Baralis, Belussi, Psaila, Basi di dati: temi d'esame svolti, Esculapio, 2000.
Revisions / Exam
Written test including database theory, SQL and database designing

Programma definitivo per l'A.A.2006/07
Back



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