|
Basic aspects of database design and management. Relational model for logic database design. Entity-relationship model for conceptual design. |
|
Good programming skills in C and knowledge of the main data structures. |
|
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 |
|
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. |
|
|