Computer engineering (Academic Year 2022/2023) - Information and communication technologies engineering (reserved for the students of Helwan University, Cairo, Egypt)

Databases

Credits: 6

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

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

Fernando Ferri

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: Characteristics of DB Approach		Evangelia Kavakli
• Lesson n. 2: Basic concepts		Evangelia Kavakli
• Lesson n. 3: Implications of DB Approach		Evangelia Kavakli
• Lesson n. 4: Database System Architecture		Evangelia Kavakli
• Lesson n. 5: The Entity-Relationship (ER) Model . Part I		George Tsekouras
• Lesson n. 6: The Entity-Relationship (ER) Model . Part II		George Tsekouras
• Lesson n. 7: The Extended-Entity-Relationship (EER) Model		George Tsekouras
• Lesson n. 8: The Relational Model . Part I		George Tsekouras
• Lesson n. 9: The Relational Model . Part II		George Tsekouras
• Lesson n. 10: ER-To-Relational Mapping; File Organization		George Tsekouras
• Lesson n. 11: Introduction to SQL		Christos Anagnostopoulos
• Lesson n. 12: Table Basics in SQL		Christos Anagnostopoulos
• Lesson n. 13: Data manipulation in SQL. Part I		Christos Anagnostopoulos
• Lesson n. 14: Data manipulation in SQL. Part II		Christos Anagnostopoulos
• Lesson n. 15: Advanced SQL		Christos Anagnostopoulos
• Lesson n. 16: Optimizing database transactions - Web Database Concepts - Introduction to MySQL		Damianos Gavalas
• Lesson n. 17: Introduction to MySQL: command-line, administration tools and user rights system		Damianos Gavalas
• Lesson n. 18: MySQL: Practice with MySQL Monitor, Creation of tables & indexes, data types		Damianos Gavalas
• Lesson n. 19: Managing MySQL databases with the phpMyAdmin administration tool		Damianos Gavalas
• Lesson n. 20: Web applications enabled by PHP-MySQL interaction		Damianos Gavalas
• Lesson n. 21: The Microsoft Access DBMS		Evangelia Kavakli
• Lesson n. 22: Exercises on the ER Model and the EER Model		George Tsekouras
• Lesson n. 23: SQL exercises		Christos Anagnostopoulos
• Lesson n. 24: Advanced SQL exercises		Christos Anagnostopoulos
• Lesson n. 25: Forms and reports in MS Access		Damianos Gavalas

Please login

Please login

Menu secondario

Computer engineering (Academic Year 2022/2023) - Information and communication technologies engineering (reserved for the students of Helwan University, Cairo, Egypt)

Databases