Corso Vittorio Emanuele II, 39 - Roma 0669207671

Ingegneria Informatica/Computer engineering (Academic Year 2006-2007)

Databases


Content language:Italian
Course description
Basic aspects of database design and management. Relational model for logic database design. Entity-relationship model for conceptual design.
Prerequisites
Good programming skills in C and knowledge of the main data structures.
Program
Fundamentals of databases • Information Systems and Databases • Database Management System Architecture • Conceptual and logic database design • Conceptual Models: • The Entity-Relationship Model (ER), The Extended-Entity-Relationship Model (EER) • The relational model: relations and tables, relational algebra, integrity constraints • SQL: DML and DDL in SQL • SQL queries • Integration of SQL in programming languages • Transaction optimization • Sample DBMS: MySQL, MS Access
Book
P.Atzeni, S. Ceri, S. Paraboschi, R. Torlone, "Database Systems", McGraw-Hill Database Systems: concepts, languages and architectures (P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone) McGraw-Hill, 1999. ISBN 0072353872.
Professor/Tutor responsible for teaching
Massimo Poncino
Video professors
Prof. Evangelia Kavakli - Aegean University (Mytilene, Lesvos - Greece)
Prof. George Tsekouras - Aegean University (Mytilene, Lesvos - Greece)
Prof. Christos Anagnostopoulos - Aegean University (Mytilene, Lesvos - Greece)
Prof. Damianos Gavalas - Aegean University (Mytilene, Lesvos - Greece)
List of lessons
    •  Lesson n. 1: Basi di Dati  Go to this lesson
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
    •  Lesson n. 10: SQL (I parte)  Go to this lesson
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
    •  Lesson n. 14: SQL (V parte)  Go to this lesson
Paolo Atzeni
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone
Riccardo Torlone