|
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
- The relational model: relations and tables, relational algebra, integrity constraints
- Normal forms
- SQL: data definition and queries in SQL
- Resources and privileges in SQL
- Integration of SQL in programming languages
- Transaction optimization
- Fault management
- Conceptual and logic database design
- The Entity-Relationship model.
|
|
P.Atzeni, S. Ceri, S. Paraboschi, R. Torlone, "Database Systems", McGraw-Hill |
|
|