Corso Vittorio Emanuele II, 39 - Roma 0669207671

Computer engineering (Academic Year 2011/2012) - Computer Engineering

Information Systems and Databases


Credits: 9
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
Programming
Objectives
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
Database Systems: concepts, languages and architectures (P. Atzeni, S. Ceri, S. Paraboschi, R. Torlone) McGraw-Hill, 1999. ISBN 0072353872.
Professor/Tutor responsible for teaching
Paolo Prinetto
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)
Prof. Mohamed Shaheen Elgamal - Arab Academy for Science, Technology and Maritime Transport
List of lessons
Barbara Pernici
Barbara Pernici
Barbara Pernici
Barbara Pernici
Barbara Pernici
Barbara Pernici
Barbara Pernici
Gabriele Lazzi
Barbara Pernici
Barbara Pernici
Barbara Pernici
Barbara Pernici
Barbara Pernici
Barbara Pernici
Barbara Pernici
Gaetano Santucci
Gaetano Santucci
Gaetano Santucci
Gaetano Santucci
Fabio Schreiber
Fabio Schreiber
Fabio Schreiber
Fabio Schreiber
Daniele Munari
Daniele Munari
    •  Lesson n. 26: 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. 35: SQL (I parte)  Go to this lesson
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
Paolo Atzeni
    •  Lesson n. 39: 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