Corso Vittorio Emanuele II, 39 - Roma 0669207671

Management Engineering (Academic Year 2018/2019) - Economics path

Information Systems and Databases


Credits: 9
Content language:English
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
Francesco Saverio Nucci
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
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Mohamed Shaheen Elgamal
Evangelia Kavakli
Evangelia Kavakli
Evangelia Kavakli
Evangelia Kavakli
George Tsekouras
George Tsekouras
George Tsekouras
George Tsekouras
George Tsekouras
George Tsekouras
Christos Anagnostopoulos
Christos Anagnostopoulos
Christos Anagnostopoulos
Christos Anagnostopoulos
    •  Lesson n. 35: Advanced SQL  Go to this lesson
Christos Anagnostopoulos
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Damianos Gavalas
Evangelia Kavakli
George Tsekouras
    •  Lesson n. 43: SQL exercises  Go to this lesson
Christos Anagnostopoulos
Christos Anagnostopoulos
Damianos Gavalas